Search results for query: *

Thanks, I'll give that a try.

Thanks Zathras. I didn't understand the difference. Maybe the SQL intro course would be a good start for me.

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...

Elysium, Thanks for your help. I will give this a try. Again, thank you for your time.

***Code to add. Note the code between * *. This is where you will have to add names to suit your particular scenario. Remove the *. These are only there to help you identify the changes you will need to make, but leave “” etc, if present, as these are very important. There are two parts of the...

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.

Bastien, Thank you for your help. I will also check out the web sites you suggested. Again, thanks!

Bastien, Could you give me an example of how to code the on open event? I do appreciate your help. I'm new to using coding. Most of my Access knowledge in "coding" is with macros. Thank you. Seawave

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...

The field is not unbound and the font color is black. The cursor does not move in the field when I try to key in the data value. Any other thoughts? Thanks.

'Viper, Thank you for responding. I will check the font color.

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.

Ken, In my subform AddNew code I have the code: Set frm = Forms!WORKACTIVITY I do not have any code referencing "WorkActivity" in my main form (Existing Ring Diagram). This is the code I have in the subform WorkActivity in the AddNew command button: Sub AddNew_Click() Dim rst As...

Thanks Ken. I'll give that a try.