Search results for query: *

Can someone help me with how to link an excel spreadsheet to use with my Access db. It is a very large file (20k lines). I thought it would be better to link the file instead of importing it as a table. Thank you.

I am trying to learn more about how to use vb coding with my Access database. My community college are offering online courses in Intro to SQL and one on Intro to VB. Can someone tell me which course I would most likely need to take? Also, if I could afford both, in which order I should take...

I have a combo box with values from a table. I want to be able to have my users add values to the table via the combo box on my form. I have changed the "LimitToList" property to No. This allows me to type a value in the combo box without getting an error message, BUT, the value does...

Hi, I know there have been some topics on how to spit a database, but I can't seem to find the threads. I would greatly appreciate it if someone can help me understand how to split my database using my local drive and using a shared network drive. My database is currently on a shared network...

Hi, I'm fairly new to Access and was wanting to make a backup copy of my database. Is there a backup command in Access? Thank you for your help.

I have an existing table where the data is not current. I want to "refresh" or update the existing table with a new Excel spreadsheet that has the most current information. The fields are the same. I just want to be able to add the new rows of information to the existing table. Any...

I have inherited a form from another user. I have a field on the form that I can not enter data into the field via the form. The field is marked NOT required. I do not get any error messages. I type the data on the keyboard, but no text is entered in the field. Wierd, but that is what is...

I have a table in my database that needs to be updated. The table's data is generated from another system in excel format. When adding the table to my database I needed to add an extra column in which I added the data to that column. I need to refresh my table to have the latest updates from...

Hello, I have a query that I run in the background,base on a choice from a combo box on my form. I would like to make the choice from the combo box and have the results displayed as a popup form or design the query to display on my form. The query does exactly what I want it to do, except I...

Can anyone tell me if there is a forum for help on how to build a form in MSWORD? Thank you.

I have a main form and 2 subforms. When testing the subforms as standalone forms the values update and the textboxes return to null for the next entry. However, when I enter data values on the subforms, as a part of the main form, the subform values will not update and return a null value when...

I have a table with 10 records in it. On my form the naviagation buttons show that I have 10 records. On my blank data entry form, I press the "previous arrow" to view the 1st or any one of the 10 records via my form, but the data does not display in the form's textboxes. The...

I have 2 subforms on a mainform. When the user completes the entry on one of the subforms I want the focus to go to the first field in the next subform. I have an AddNew command button on the 1st subform to save the data to the appropriate table. After the record is saved and the form textboxes...

Paul, below is the coding you provided to me. I'm not certain what I've done wrong...I added the coding to the AddNew command button, however, I get a "compile error - user defined type not defined" and the first line of coding is highlighted in blue. I'm new to the board, so I'm not...

I have a form with unbound objects and I do not know how to write the code to tell Access to save the value to the field in my table. Example: my user types a value of F0002 in the unbound textbox on the form. The field "CableName" is in my Cable Table. I want to save the F0002 value...

I have several combo boxes on my form for my users to select a defined value. The combo boxes are unbound and I dont know how to write code that will save the user's selection into the field on the table were I want to save the data. Ex: I have one combo box that has specify cities loaded for...