Search results

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

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

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.

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

I have a form with three subforms. all is well except for recent entries in subform frmContactDetailsSubformRF, linked by StationID that says..."you cannot add or change a record because a related record is required in table "tblStationData2". "tblStationData2" is a table that has been renamed...

I have this table: etc and I need to look up, say,the figure ($) in ZoneD for the KGWeight say 2.0 and get the result of 39.21 DLookup("[ZoneD]", "tblWeightZonesFedEx", "[KGWeights] = " & Me.txtCalculatingWeight) would be fine if I only had ZoneD but there are approx 20 such zones. I know which...

I have this situation: one table holds all the contact people for Manufacturers [tblSuppliers], another table holds the contacts for Distributors [tblDistributors]. The problem is that a few companies are both Manufacturers of products and Distributors of other company's products. I need to...

Is it possible to hide a label on one open form by the click event of a control on another open form?

My database has a field "Town" as part of the address of each customer. Each town (say Brisbane) can have many customers, so when i use a combo box to select a town I get multiple instances of each town. How do i get it to show only one instance of each town? Thanks in advance Bob

Hi, For this particular database, in query design mode I right click to bring up the menu, the click on "Show Tables" and nothing happens...no sign of the list of tables that normally appear to the right. This has only recently occurred...Could I have changed something in File..Options? Thanks Bob

I have two tables joined by StationID. In a query that shows which companies (stations) have a link (RPCustomerPoNumber) to field in the other table, but I only want to see that company name once. The query is unbound. SELECT DISTINCT tblRepReport.StationID, tblStationData.[Station Name]...

I have an SQL query (Query1) that gets its data from two different tables...works fine. SELECT tblProduct.ProductID, tblProduct.PartNumber, tblProduct.Product, tblProduct.Purchaseprice FROM tblProduct UNION SELECT tblProductsMYOB.ProductID, tblProductsMYOB.PartNumber, tblProductsMYOB.Product...

I have a need to limit the number of times a company comes up in a query result. I have two tables: tblStationData, and tblSerialNumbers I have tried SELECT DISTINCT tblStationData.StationID, tblStationData.[Station Name], tblSerialNumbers.SerialNumber FROM tblStationData INNER JOIN...

I have a table imported from Excel...(Screenshot below) It relates to freight charges and I am required to programme vba to allow the user to enter say 2.5 Kg and Zone 4 and have the answer 109.75. I have no idea so am looking for any ideas which will be much appreciated Thanks Bob KG...

I have a form (frmContactDetailsPower) with a form (frmProgressiveNotesEntryPower) linked by [StationID] from txtStationID. Form frmProgressiveNotesEntryPower is linked to a table (tblProgressiveNotes). I need to be able to search the table (limited by the StationID) for each instance of a...

Hi, I am a selftaught access programmer working for my son's company. I am by no means professional