Recent content by Fliption

Thanks for the help. Unfortunately I can't seem to get this to work. Before I proceed, let me ask this question. I'm not very astute at VBA so pardon my ignorance. It looks as if this code is looking for a backslash to split the full path/filename into a path and a filename. Does this still work...

I have been using some code that allows a user to browse for a file in order to import it into Access. It works like a charm as long as the data to be inported comes from another access file. The module that allows the user to select a file is simply saving the path and filename selected as a...

Would this work if the 2 forms in question are a mainform and a subform? When I open the main form, I don't want the subform to try to pull data until the main form has completely loaded.

Nice Idea. For a brief moment I thought that might work. When I tried it, I realized I had forgotten why I placed the word "timing" in the title of this thread. Even with a default value I still get this error. It's as if the queries in the subform are trying to run before it recognizes the...

I'm having an issue with an error message when the main form is opened. So if I could keep the subform and underlying queries from running when the main form is open, then you're right, requerying the subform after the zipcode update would be a necessary step. Any idea how to make a subform...

Well I have gotten beyond the tough part of my project only to run into a quirk that I never expected. I have a form where a user can input a zipcode and then a radius distance in miles. The subform then shows all of the zipcodes within the radius distance from the original zipcode. Once a user...

Hi Pat. Your query worked fine. I just wasn't able to understand how it worked well enough to be able to adjust it or add to it. I would love to know more about how it works though because it's syntax is very different from the sytax of the SQL that I see when I design a select or append query...

Wow. I just found a seemingly much easier (for me) way to do this. I saw Uncle Gizmo respond in this thread with this idea. http://www.access-programmers.co.uk/forums/showthread.php?t=113612&highlight=append I just need to set up an append query with each of the tables included and DO NOT...

I apologize for being dense but I've tried all sorts of things like this. The problem I'm having is in the 2nd to last line in your code. I can insert an additional field into the SELECT and INSERT INTO commands easily but the FROM statement in your code doesn't resemble anything that comes out...

Anyone else want to take a stab at this? Pat was kind enough to provide code that will insert 2 fields from 2 different tables into a single record of a third table. It works perfectly well but I now realize I need 3 fields from 3 different tables put into a single record in a 4th table. The...

OK I think that error was associated with some changes I made as I worked through the coding errors and not the code itself. Also, I decided it would be best to link this code to a specific command button as oposed to some general action like opening the form. This command button will only be...

Thanks for this. After tweaking with several errors I finally have your code working. The code will do exactly what I want. The only problem is that it still gives me this error: "The expression is typed incorrectly, or it is too complex to be evaluated". The code works perfectly by inserting...

Pat, I am trying to accomplsih what you described in the quote above. To make this work and have the riskID field listed in the form I will need to append them into the Measurement table as you said. But the primary key for this table is the combination of ActivityID and RiskID, so I will also...

That's an idea. Thanks for your help. As info, I have set it up the way you described before and now when I select a RiskID from the combobox it automatically adds another combobox below it. This is much better than the user having to click the next record buttons. But I'm liking this append...

I have found that developing databases (currently using Access) and front ends for end users is something I really enjoy doing. I'm wondering if there are any types of careers/jobs out there that would focus on this? I do database stuff for work but it is in my spare time. It isn't my primary...