Hi Yep, there is a connection between the forms: the main forms primary key (an ID number - automatic counter), and a field in the subform (foreign key). The...
Erik- You shouldn't allow the user to enter subform records when the outer form is on a new record. You can trap it in Form_BeforeInsert: Private Sub...
Hi, Mike, Hi everyone. As John said, the new code sample is required. Another thing I would like to know is what you want to achive with the two recordsets. ...
A.D. Thanks for sticking with me on this. I'll go back and review your sample again and with this explanation I should be able to understand it. I didn't...
I'm not sure I will be able to do that until about Tuesday because of my schedule is pretty tight through Monday. Thanks for you help. I did learn how to...
Jim- You can do it in the Open event of the form: Private Sub Form_Open(Cancel As Integer) ' Force the recordset to load Me.SetFocus Me.SomeControl.SetFocus '...
I posted back in February and never saw an answer (I just checked the web forums and there was no answer). I'll try again. Any insight would be appreciated....
Try: InjectionTotals: DSum("InjTotal","tbl_ColumnLog","LC_Column=" & [Enter Column ID]) You might also need to explictly declare [Enter Column ID] in Query / ...
Glad to help. Be sure to let us know how you make out. It would be very interesting to find out how much space you save depending on which graphics (if any)...
In MS_Access_Professio <mailto:MS_Access_Professionals%40yahoogroups.com> nals@yahoogroups.com, "Bill Mosca" ... again I will shoot myself. And you'll save...
'By the way, you mentioned from the beginning that this is an unnormalized table - and that's really the root of your problem. Why are you forced to use the...
You'll get no argument from me, Kimberly. Another pet peeve of mine is a website with a black background and blue or red text. What were they thinking?! Bill ...
Sorry John, I don't have the code now. I started going in a different direction, but still having issues with it too. Ultimately, my procedure needs to be...
Hello, I have been asked to produce a report about network signons and I was wondering if there is a way to access the AD from Access/VBA and pull data such as...
Kimberly- That makes sense. The toughest jobs usually involve trying to clean up someone else's mess. You'll probably need a lot of these ugly queries to try...
Mike- Sounds like a simple query problem to me. What's the structure of the tables involved, and what do you want to see (or not see) in the output? John...
James I just uploaded a file named basActiveDirectoryUserList.bas to our Files section. I got it from somewhere on the web. You can probably use it as a ...
John - Below is the select code. My thinking is that I use two loops. 1. The first captures the investor number. 2. The second runs through the record set to...
I had to comment out the line Me.SomeControl.SetFocus Then it worked. I tred changing it to Me.FormcloseButton.SetFocus but it still didn't work but...
... When I do that I get "Data type mismatch in criterion expression" when running the query. The column field type is a text field, but the values I'm...
Mike- No temp table should be required. If I understand your problem, you want all Investors (Master_Table?) who have no date-stamped record in the ...
It should have worked if you declared the parameter as Text. I'll have a look when you upload. Just reply to this thread to let me know it's there. John...
Hmmm, I tried the below process and it seemed to work fine, however when I re-opened it, the file actually INCREASED in size by about half a meg. Is this bad?...
Lee An increase in size is expected when you open it. But it should go back down when it is closed if the Compact on close is set. Depending on the amount of...
After you decompile, when you open it recompiles so some increase would be expected. After the Slight increase, is it smaller than it used to be. If so that...
John - The form will display non-approved records (i.e. records from the Master Table that are not = 1/1/1900 in the Verification Table.) Initially, the user...
Mike- I'm sorry, but I still don't get it. I asked you to post the structure of the tables and the relevant fields, and you didn't do that. 1. What's in...
Dear friends, I need your help, I am trying to find a way to calculate the value of the inventory based on
First In First out, Please if you an example send it...
In order to create a FIFO inventory control you would need to include a delivery date or some kind of sequential ID field. The item cost would be included...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
