Search results

Rural guy, that looks good for the times the form is opened and the transaction number is known, how do I get my code to deal with the time the form is opened and the transaction number has to be prompted for?

Minty interesting approach, in my query I have a field with a prompt [What transaction do you need?] This is run all the time, what I would like it to have the value filled in automatically if the form is opened from particular controls. What I am trying to avoid is having two copies of the...

I can see how you are thinking of passing parameters, how do I then use these parameters in the select query to either get the user to enter the data, or use the data passed? My problem is not so much passing information, but trying to open the form with a query that asks the user for...

I have a form, in two places it is called from VBA code and I would like to supply the required number that in the 3rd place the user has to enter. Can this be done? What I mean is there is a button where the user can open a form, for editing. The user is required to enter the transaction...

You are a life saver!!! That worked perfectly! Thanks!!!!!!!!!!!!!

I have a form, has lots of fields on it. Nothing new here... Here is the tricky part, there is a few fields are being filled by a query that is not embedded into the form. There is a query embedded into the form, but it does not contain the required fields. When the form comes up the field...

I took out the record source and saved the form, went back in and selected the record source again and saved. Same issue is happening. The query is being pulled up without prompting for the selection criteria. If I open the query directly I am prompted so the query works, just not in the form.

I have a query that has a prompt in it for data selection. (['Customer Number']) This used to work just find, but now for some unknown reason when I open the form it no longer prompts for the selection. What I have been working on, is adding a couple fields that are not in the query at all...

Was afraid of that. So basically I need to call a routine on almost every trigger of ever element on the form in question.... Not what I was hoping for.

Here is an odd problem. Does a form element trigger get fired if the trigger is caused by another element? Specifically, I have a field "Customer ID" I have a trigger "On Change" which causes a bunch of VBA code to executed. But I also what this code executed if the user click on the "Next...

Audits are to Databases what Lot Traceability is to inventory control. They are nice, but you are best served by running away unless you have to implement. For Audits, the questions are still out there, what are you trying to audit? Is it just an update audit flow, or a read/write audit...

What sort of database, how many tables?

Sorry to take so long to get back to you. Yes can update either of the two tables if I only pull up one table in a query. Both tables have a Autoinc field (ID in my case). The join is on the Access side, I guess I could look at making it a view, but that means a lot of extra code I am hoping...

I have a VBA routine that is called from a button on a form. This code opens a table containing a bunch of audit records, then processes each records. Part of the processing is to go to the master parts table and update two fields. Because of the way the audit table is created I am guaranteed...

Passthrough is not working for me. Now I have the issue of the queries that have been made passthrough I can not change back to normal queries. Is there a way to do this?

Hmmm I think I am doing something wrong here. I took one of the queries and clicked on the Pass Through option. When I open the form that calls up the query I now have to select the DNS and then I get the following runtime error #3146: replation "partsworkorder" does not exist while...

Not ever done that, is there anything special I need to do to do a passthrough query? or if it a toggle switch somewhere in Access?

I have migrated all my tables onto PostgreSQL, everything is working OK, except for one issue. All my queries that reference two or more tables are now all read only. This is a major hassle, I have got around a lot of the little ones by simply opening the table in question in VBA and update...

Don't have the users go after the table directly have them reference a query. Then in the field have a calculation. Something like this: Field:QTY Field:Cost Variable:Extended:[QTY]*[Cost] The Access SQL code would look like this: SELECT public_parts.onhand, public_parts.lastcost...

I can update either of the tables independently in Access. As for a union, I do have the two tables in a JOIN. Do not think I am using the UNION verb, unless Access is doing that behind my back. When I display the SQL code is Access this is what is shown: SELECT PageCount.*...