Search results

Brilliant! This seems to be exactly what I need. I shall do some more Googling to get a better understanding, and then work on changing my code. Thanks!

Hello all, I have code that loops through a lot of objects, and adds them to a table. Right now I have suppressed the warnings via the DoCmd.Setwarnings = False command, in order to avoid the user seeing the message confirming that they want to make changes to the table. However, I WOULD like...

Okay, so I see that I should be using Me!fieldname rather than Me.fieldname to reference what I am looking for (to be clear, the code is running within the subform, so I'm not actually needing to reference another form. I probably shouldn't have mentioned the subforms at all to avoid confusion.)...

Hey guys, I've got a simple question. I have two forms - both of which are subforms on another form. Each of them is linked to a different table. The master field/child fields are linked to the main form, and those fields do not have controls on the subform as that is unnecessary for me. On...

Hey guys, this is the query I am attempting to run: The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. Can someone explain to me what I am missing? I need these sorted by the NumberofReRoutes field, but this...

Holy crap! That link was exactly what I needed. It works! THANKS!!!

Ok. Sorry to drag this thread up from the dead! After several months I've finally "finished" this database with the exception of this one piece, and I'm ready to devote all of my attention to making this happen. I did try changing the link to the URL as vbaInet suggested, but that does not...

Hello all. So I have a main form and a subform. Long story short, I do not want to allow the main form record to be submitted unless there is at least one subform entry. Initially I thought it would be as simple as a "Before Update" event which would test the record count of the subform. This...

Sorry guys. I got roped into ANOTHER Access project for the past two weeks. Just wanted to come back and say thanks! In all my research, I never happened to stumble across the term compound primary key (or composite as they call it, apparently.) This was all I needed to figure things out. Thanks...

This is indeed part of a much larger database I am building to track all sorts of things. The 'Badge' field is a drop-down which is populated from an "EMPLOYEES" table which has First Name, Last Name, Work Location, etc... And don't worry, the field names I listed were just representative to...

Thanks for the help guys. So this is what I've come up with so far. I think I'm headed in the right direction, but I've still got a few issues that I need to work out. I've split my tables as such: Table1 -Employee Badge -Date -Some other fields about the current day -Remarks Table2 -Employee...

So I know you guys on here like to harp on everyone about proper database design and structure, so I'm sure there is someone who would love to answer this question. I have a table which holds records for an employee's work day. As it stands right now, along with all of the other information...

Yup. Turns out the code above works (it was the hashtags that I was missing originally).

You're right! I wasn't even being given a 'debug' option in the error window. Turns out it pulled that code into the "Filter" property of the form and didn't update when I changed it in the VBA window. Fixed! Thanks!

Can someone tell me how to solve my data type mismatch? It is supposed to be filtering records to only show those where the user-entered date falls between the start and end date. I can't seem to figure out the proper way to relate the date in the text box. I've also tried without the hashtags...

So surely someone must know of some sort of solution for me!

Hello all. I am trying to import an HTML table into Access. Someone suggested I use ACE/Jet, which I got working with the following code: However, the original goal was for this to pull straight from the web page - not from a copy of the web page saved locally. Does anyone know if this is...

I had tried making that actual change, FYI, but I assumed I was wrong because when I DO change it to Me.RecordID, that's when I get an error when I try to compile it (Method or data member not found.) EDIT: FINALLY SOLVED!!! I actually had to get rid of the prefix entirely, and make it JUST...

I did. That works, but I'm still getting the same object defined error... I appreciate your help, but I'll just see if I can do things another way. I'm not sure why this is so difficult, but I've been trying to get this working for the better part of the day and I'm running out of patience.

I can make its source a query, but won't that mean I can no longer add or edit records?