Search results

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

Thanks again Pat. I understand about the primary key not allowing duplicates but are you saying that the user will have to click on the next record button at the bottom of the form before they can input a measurement for RiskID 2? What I would really like to do is have all 7 RiskID's listed...

Thank you Paul for your response. I believe I did do what you are suggesting. What I end up with is a single combo box with risk id and a field to input the risk measurement as you said. The problem is this: Once I select a riskID from the combobox and then enter a RiskMeasurement, the 3rd table...

I have been trying to figure this one out for a while and I can't seem to find anything helpful. I'm going to present a simplified version of my problem to help keep it simple. I have an "Activities" table that contains fields: ActivityID ActivityName I have a table of 7 Risk areas which...