Search results

I have a form for looking up records. There is a text field on the form to put in a number that can be found in the table (tbl_data) field named 8DNumber which is a number field. A subform in datasheet view is on the form to show the results of the search with the linked fields being 8DNumber...

I am asking for help on another part of the attachments thread located here: https://www.access-programmers.co.uk/forums/showthread.php?t=247009 I didn't want to add it to the bottom as it is already 3 pages long. Ok... I have an attachments form opened via command button on a form that...

I know there have been many threads regarding this error but I have narrowed down the culprit but do not know what needs to be fixed. This only happens to one of my forms in tab control but it is complicated. History... Tab control main form (frm_home) Form on a tab having issues...

I have to let go of starting the new records in my database and my OCD alarm is ringing like crazy. On my record input form there is a field for putting in a PO number (tbl_auditdata - PONumber) and typically the PO number looks like this: P0FG456. At this time there is always a P for the first...

I have a form with 2 comboboxes and a command button. Combobox 1 is irrelevant for this question. Combobox 2 is for pulling a list of all reports. Command button is for generating the report from the choices in the comboboxes. Combobox 2 has this imbedded query in the Row Source: SELECT...

I have started many threads on this forum over a short period of time and while I have been vigilant in clicking the "Thanks" link in their posts... I wanted to take a few minutes to properly thank the people on this site that helped me (and everyone else). Isladogs (Colin)... you nudged me in...

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

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

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

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

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

Through the great help by many here the re-write of my database is complete and fully functional. However I really need to re-address the seriously slow loading of my main form (frm_home) after changing to tab control from navigation control. This was dealt with briefly in another thread but...

In another thread I was asking about issues with my reports opening minimized due tot he setaccesswindow code. I was able to get around that with some properties settings for the reports... However I just realized this morning that my export to excel no longer works. There are three modules...

Colin, (or anyone else that is familiar with this) I am trying to use your code in teh SetAccessWindow database sample found here: https://www.access-programmers.co.uk/forums/showthread.php?t=293584 to only leave up my main form (frm_main). I do not need command buttons to make this happen... I...

I have this module to hide the close buttons in the access application to force the user to use my command button on the main form to close the database. It has the PtrSafe added in to make it work with 64 bit systems but I have one user out of all users that is still on a 32 bit system. Is...

Since I have been re-writing my database to use tabbed controls rather than the navigation forms I have run into several issues. One of which is running my reports from the form in my tabbed control I worked with my form (frm_reportcenter) and put an unbound combobox (cboFacility) to choose a...

Through other threads of asking and receiving help on my database it was suggested that I ditch the navigation form layout and go with tabbed controls. I was finally able to figure out how to get all of the forms in the tabbed control and them function correctly. I was being stupid and was...

I just noticed a strange thing happening in my database. I have 2 data input forms that do not create new records but only update information in existing records. The random thing happening is the code behind the forms is set to log the UserID in each record of the persons making the edits...

ridders... I have been searching and reading for several days now and am a little confused about storing files externally. From what I am seeing you have to manually put files somewhere and then manually put a link in the database to them. Am I correct in this? Is it not possible to have the...

I have a little form that has 3 buttons on it. One button generates an export to Excel of one kind of data. Another button generates an export to Excel of another kind of data. The third button attaches the exported Excel files to an email in Outlook and sends it without having to see it. This...