I'm developing a national database for deployment hopefully by July/August and want to know if there is any UK 420'ers who could help me out with a few problems I have with SQL code & VBA code,
I won't put the deails of the problem(s) unless I get a helper but in short it is :
This is a National database:Complaints Referal and Resolution Service (CRRS)
I've got 'queries' which retieve 'post codes' and 'location'. I want to store these values (fields) in various related Tables & Forms.
I'm doing a Freebee for a 'Disability' Agency.
Thanks for any assistance
Full Version: Any Ms Access 2000 Developers Around
I would store the values you get from the select query in a field or a variable, and then place it into maybe a temp table using an insert or update query, or referring to the variable you defined from within the form.
Not great at that stuff, but I can muddle through
Not great at that stuff, but I can muddle through
Thanks for your speedy reply OMH.
| QUOTE |
| using an insert or update query, or referring to the variable you defined from within the form. |
I'm heading for a query (which I have now) wich once the input for the Location_Fld has been ented and 'before update' run the query returning the values for State & pot code (Zip Code). So I have the Query but when it executes I end up with a 'dynnaset' & need to get this into the form and the table on which it is based.
I'll try to work out the 'Where' statement as it is now the criteria is asked for input a 2nd time as a parameter on which the other information is returned. the other consideration is being a national records for Australia ther is over 6,000 locations P/C's.
Thanks OMH -I'll look into assigning the returnned values to variables and see if I can use an update query. There has to be a simple way to do it. I know that the location data entry field on there form has to be an unbound field.
| QUOTE |
| I've got 'queries' which retieve 'post codes' and 'location'. I want to store these values (fields) in various related Tables & Forms. |
Dude, I know that I sort of missed the boat with this one, but Nitramkram, if ya still out there, let us know how you are getting on. Anyway...
My understanding was that the results of queries were drawn from the data stored in tables. I also thought that the fact that the original table stores the information would be sufficient. The form you are designing would update the data in the original table. If you need this data again, for another form or query or whatever, just take it from the original table.
Maybe I'm not getting the picture here?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.