Search results

Thanks all will work on it

This works to show current linked tables My problem is that it seem to be saving the records to a different tblVisits in another, previous saved, backend and i cant figure out where

I have a form writing to a table that appears to be in an older version of the database. how can I find this table. The for opens, accepts data and closes without any error mesasage. The data file (split database) has been backed up numerous times but I cannot find the table (tblVisits)...

I wish to find and track miss spelt products in the Products table. I guess ProductID, PartNumber, and Product (the description) are the items in discussion. I wish to find products that have been mis-entered EG spelling or spaces that should not be there. a sample would be 100B470JT500XT and...

The need to test is to deny duplicate entries. When an order is received it notes both the manufacturer's part number and description as well as the part number the customer gives the product. We need to record both. The manufacturer's part number is usually in the system. There is an entry form...

Thanks Doc man Like I said...Difficult and you just made it more so! The structure of the product table (tblProducts), is ProductID...PartNumber....Product etc etc (Product is a detailed description of the product) The structure of the table recording the Customers associated part number is...

I have have two tables...tblProducts and tblCustomerPartNumbers. I need to record the part number a customer gives to a product that the manufacturer has given a part number, ie the manufacturer builds a product and sets the Part Number as R5G100, but the customer lists it as 000-123-00. I...

Thanks, you guys are unbelievable! Answers in less than an hour. I have used Me.txtNextContactDate = DateAdd("d", 7, Date) and works fine

I have received great help for this post ( I have a form in which we enter a date, say for when we receive an order say 21/08/2024. I wish to have the entering of that date trigger a textbox entry for a date that is say, one week more. Thanks guys Now how would I do it using the Now Function...

I have a form in which we enter a date, say for when we receive an order say 21/08/2024. I wish to have the entering of that date trigger a textbox entry for a date that is say, one week more.

I have noted that when I click on the dependency icon the progress bar at the bottom of the screen says "searching for Dependency information"

Database is split Not sure what a persistent connection is. I work, adapt, make changes etc, to the front end on my home machine. I log onto the server to update the server.Users then log on to their virtual machines. Database has grown quite large and as it has been created and adapted as the...

I am opening it from the toolbar tab. I see the progress bar operating so obviously the "programme' is functioning but no pane appears to interact with

In this database only, the Object Dependency Pane does not show even though I see the progress bar at the bottom of the screen doing its bit.

I want the user to see the file but not to save it necessarily. I assume they would be able to choose to save if they wished.

Thanks theDBguy DoCmd.OutputTo acQuery, "qryRepreportCompany3", "MicrosoftExcel(*.xls)", , True works fine. Saves the file, and while this is Ok=K, an option to NOT SAVE would be great Thanks for your prompt reply Bob

I am using : DoCmd.OutputTo acQuery, "qryRepreportCompany3", "MicrosoftExcel(*.xls)" to open the query results in Excel. This works OK but I would like to open the spreadsheet automatically once it is created. Saving is not necessary. All help appreciated

New contacts are added via a subform of the main form of customers. Customers are added via a separate form. If I look at the Contacts table the new contacts are listed but the joining StationID is missing. If I try adding it in datasheet view I get the error message "you cannot add or change a...

I cannot find any such references. If it helps, the problems only exists when I enter a new customer and then try to add a contact. There is no problem in adding a contact to older customers

Have read mentioned articles...tried to find any reference to "tblStationData2"...none found...rebuilt forms etc...no change Need help at my self taught level.