Recent content by New_Guy

Hey thanks for the advice.

EDIT": hrmm this time i found an error. Thanks

When i try to create a .MDE file this is the error message i get. "This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet...

was a solution ever found for this?

Will do all of that ASAP. Thank you very much for your time and effort. Its great to be able to get help from the pros.

Hey Bob, I can probably remake the entire form and just copy/paste the buttons and code faster then i can find a fix. I really just thought this would be an easy fix, like re-linking a library to this form. It seems as if i did some kind of function override on this form. I will post my...

The field was named datediff and had the data type of a number. On the form it was a text box - sorry for the misunderstanding. I use the combo box feature all the time to link one table to a field in another table and that works great for me. Maybe its not a good programming method but thats...

Ok, i went into the table and the field name datediff which happens to have the display control of a "text box" was renamed to DD.

I didn't change the name of the table. i changed the name of the text box within the table. I then went back into my form, deleted the code and text box associated with the datediff name and added the text box DD. I then recoded my button to look like this. Dim d1, d2, d3 As Variant d1 = Date...

Hey, just wanted to see what you all thought before i totally rebuilt this form. Here is a little info on the problem i am having. I am a new to access so i will try to provide enough information on what is going on. I have a form that has two date fields and i need to know the difference in...

This is great stuff, thanks for the help. Mark

Hello all, I am new to Access and I could really use some help to point me in the right direction. I want to organize my tables properly from the start so I do not run into problems down the road. If anyone can give me some advice on topics to read it would be a big help. Here is what I am...