Search results

Yea... told ya I didn't know what to do. You code worked perfectly. Thanks a million Gasman. :D

That code gave me a Run-Time error 3144 syntax error in UPDATE statement.

Back to this thread again. In an attempt to make an admin panel form for my database I wanted to add a popup form with a text box and a command button. From this I would like to be able to type in the new version number and click the button and have it update the fe_version_number field in the...

I got an email saying that someone posted a reply in this thread asking for more clarification because they didn't understand... but I do not see any reply Maybe the poster deleted it?

Yea... the Categories table and the Vendors tables are only used for looking up values to keep from typing them in different every time. I changed them from embedded value lists to avoid having to update them in the forms if a new category or new vendor was added. I appreciate the feedback...

Ok... maybe I can explain my question. My database as some of you will know is not normalized and I do not plan to fully normalize it due to it working perfectly as of now. however today I added a couple more tables that I believe could be an effort in some normalization. Start with one of my...

What do the other 4 comboboxes do?

I believe I have discovered the issue. While sizing the report I realize I was using Ctrl+S on the form in design view to save the physical size of the popup report.... but apparently I did it every time I had tested the generator and chose the Ripley facility... a coincidence I guess. If I...

I have a form for generating reports base on 2 comboboxes. Randomly I am finding a filter set in the filter property of random reports which screws up what displays. This doesn't happen to all reports... it is random but the filter that I find in the property is always the same...

Thank you sir... this worked perfectly.

It turns out I had a couple of users that I can only assume they know how to bypass the code in my database because they were still using older versions than current (v015) but new enough that the auto updater code was in place and should have forced a version update like has worked for everyone...

Ha ha nevermind... I changed the master - child links to the PONumber field and it solved it.

I have made a form that has an unbound textbox and a command button and a datasheet subform. The idea is that I can search for a PONumber (name of field) value and have it display all records with that PONumber. I tried this code but it only displays the first record containing that PONumber...

I found some code on the interweb that if the form is run from the back-end it is supposed to work like I was asking about but I have to wait until the users are out of it before I can put the form in. It would be nice if a form can be linked to the front-end like a table... then I wouldn't...

That is the part I was hoping for Definitely not what I was referring to... All people in the company can log into any computer and it is just like if they were sitting at their own desk and would have their own copy of the front-end under their own login credentials. In one lab we have 4...

For informational purposes this works on access 2013 64 bit and windows 7. This same information can be obtained by clicking on the little locked file that is created (where the back-end is located) when someone is in the database (and choose Microsoft Word to view it) which displays the...

Forgot about the queries for the forms themselves too but figured it out. It was actually pretty simple. Thanks for all the thread views all. I don't blame anyone for not attempting this from all that bla bla bla I posted :D

I totally forgot to post the querries for the comboboxes. in frm_visualinspectioninput: (qry_visinspectinputcombo) SELECT tbl_auditdata.AuditID, tbl_auditdata.PONumber, tbl_auditdata.Status, [tbl_parts].[PartNumber] & " - " & [tbl_parts].[PartDesc] AS Expr1 FROM tbl_auditdata INNER JOIN...

Is there anyone willing to help me with one more detail on my database? I have access levels which are: Visual Inspector Lab Tester Multi Tester At some facilities there are only Visual Inspectors. Because they do not have a lab... they send their parts needing lab testing to another facility...

works as is for me