How to use an form field in a SQL from a combobox
I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field [...]
Answer Question
| June 12, 2009 5:45 PM
Access 2003, Microsoft Access, SQL Forms
I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn’t work. what is the correct syntax to refer to a field [...]
Answer Question
| June 12, 2009 5:45 PM
Access 2003, Microsoft Access, SQL Forms
Update Microsoft Access database from VB6
Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and [...]
Answer Question
| June 24, 2009 10:44 PM
Database connectivity, Database programming, Microsoft Access, VB 6, Visual Basic 6
Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and [...]
Answer Question
| June 24, 2009 10:44 PM
Database connectivity, Database programming, Microsoft Access, VB 6, Visual Basic 6
enter key behavior on forms
when my user hits the enter key, i want it to return to the first field (which is hte id entry key).
Answer Question
| June 24, 2009 6:46 PM
Access forms, Microsoft Access
when my user hits the enter key, i want it to return to the first field (which is hte id entry key).
Answer Question
| June 24, 2009 6:46 PM
Access forms, Microsoft Access
Duplicating Form FieldsAccess 2007
I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.
Answer Question
| June 10, 2009 4:03 PM
Access 2007, Access forms, Microsoft Access
I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.
Answer Question
| June 10, 2009 4:03 PM
Access 2007, Access forms, Microsoft Access
Excel to Access conversion
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be “moved” into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would not merely be a matter [...]
Answer Question
| August 12, 2009 3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be “moved” into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would not merely be a matter [...]
Answer Question
| August 12, 2009 3:20 PM
Data transfer, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel
Toggle button in Microsoft Access form
Hi, in an access form I have included a Toggle button which when “on click” imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won’t import the same database. Thanks
Answer Question
| June 25, 2009 10:20 PM
Database programming, Microsoft Access, Microsoft Access forms
Hi, in an access form I have included a Toggle button which when “on click” imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won’t import the same database. Thanks
Answer Question
| June 25, 2009 10:20 PM
Database programming, Microsoft Access, Microsoft Access forms
Access Subform Repeating Data
I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn’t repeat – what do I need to do to sort this?
Answer Question
| June 3, 2009 8:10 PM
Microsoft Access, Microsoft Access subforms
I have brought in a subform into my main form and link the child and master fields, but under each page the subform repeats the information down the page, but in the report on its own (i.e. before it is a subform) it doesn’t repeat – what do I need to do to sort this?
Answer Question
| June 3, 2009 8:10 PM
Microsoft Access, Microsoft Access subforms
Grouping Query
I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 850,000 I need to write a query to pull this data and put into usage bands and count how [...]
Answer Question
| June 25, 2009 6:18 PM
Access query, Microsoft Access, Microsoft Access query
I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 850,000 I need to write a query to pull this data and put into usage bands and count how [...]
Answer Question
| June 25, 2009 6:18 PM
Access query, Microsoft Access, Microsoft Access query
Populate Access 2007 object in form
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.
Answer Question
| June 1, 2009 6:56 PM
Access 2007, ComboBox, Microsoft Access
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.
Answer Question
| June 1, 2009 6:56 PM
Access 2007, ComboBox, Microsoft Access
Connectivity between Oracle BI Publisher and Microsoft Access
I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?
Answer Question
| May 27, 2009 11:52 AM
Database connectivity, JDBC, Microsoft Access, OBIEE, Oracle BI Publisher, Oracle Business Intelligence
I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?
Answer Question
| May 27, 2009 11:52 AM
Database connectivity, JDBC, Microsoft Access, OBIEE, Oracle BI Publisher, Oracle Business Intelligence
Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]
Answer Question
| May 26, 2009 10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]
Answer Question
| May 26, 2009 10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors
Retrieving Records based on Record Selection from another table
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables, equipment, etc that are in one table. For [...]
Answer Question
| May 22, 2009 8:46 PM
Access Database, Microsoft Access, SQL Database
I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables, equipment, etc that are in one table. For [...]
Answer Question
| May 22, 2009 8:46 PM
Access Database, Microsoft Access, SQL Database
Performance Issue with an Access File Updated through an .accde file with Linked Tables
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked tables [...]
Answer Question
| May 19, 2009 6:27 PM
Access 2007, Access Database, Microsoft Access, Microsoft Access Performance
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked tables [...]
Answer Question
| May 19, 2009 6:27 PM
Access 2007, Access Database, Microsoft Access, Microsoft Access Performance
SQL or VBA code to loop through two columns of data
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product [...]
Answer Question
| May 20, 2009 12:34 PM
Microsoft Access, VBA
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product [...]
Answer Question
| May 20, 2009 12:34 PM
Microsoft Access, VBA
How a S/W in c# working in N/W accesses access database from other computer not having access
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn’t have ms-access, then how will i connect to it and run my project?
Answer Question
| May 19, 2009 12:54 PM
Access Database, C#, Microsoft Access, Network connectivity
hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn’t have ms-access, then how will i connect to it and run my project?
Answer Question
| May 19, 2009 12:54 PM
Access Database, C#, Microsoft Access, Network connectivity
Paragraph marks in an ASP blog page.
My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but [...]
Answer Question
| May 18, 2009 3:07 PM
ASP, Microsoft Access
My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but [...]
Answer Question
| May 18, 2009 3:07 PM
ASP, Microsoft Access
Access 2007 removing completed data
I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?
Answer Question
| May 19, 2009 2:26 PM
Access 2007, Microsoft Access
I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?
Answer Question
| May 19, 2009 2:26 PM
Access 2007, Microsoft Access
Open Access 2007 files with Windows 2000 OS
Is there a reader that that will read .accdb files using a Windows 2000 operating system?
Answer Question
| May 13, 2009 7:40 PM
Access 2007, Microsoft Access, Microsoft Windows 2000, Windows 2000 desktop
Is there a reader that that will read .accdb files using a Windows 2000 operating system?
Answer Question
| May 13, 2009 7:40 PM
Access 2007, Microsoft Access, Microsoft Windows 2000, Windows 2000 desktop
Access 2007: VB code to make a button press link to a specific record in another form
The database is for a set of components. One of my forms shows details about each component on a separate record (the property “Default View” is Single Form). The other form is a list of all components by component number displayed all together (the property “Default View” is Continuous Forms). The list of components has [...]
Answer Question
| November 25, 2011 9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
The database is for a set of components. One of my forms shows details about each component on a separate record (the property “Default View” is Single Form). The other form is a list of all components by component number displayed all together (the property “Default View” is Continuous Forms). The list of components has [...]
Answer Question
| November 25, 2011 9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications
Updating Combobox after new data added
Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn’t exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new contact details. When frmContacts is closed, I [...]
Answer Question
| June 25, 2009 3:07 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access
Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn’t exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new contact details. When frmContacts is closed, I [...]
Answer Question
| June 25, 2009 3:07 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access
