Search results

Hopefully, this will make sense. I am trying to open a form to a specific record if it exists, or add a record if it does not. But the check needs to be based on two criteria (the QuoteID and where "HandBraze" is True). Whenever I use the following code, it opens to a new record each time...

Hi, I'm sure there must be quite an easy solution to this, but i cant find it anywhere. I have 2 text boxes on a form with the following in the control source: =DLookUp("[Phone Call]","qryCallsCount") =DLookUp("[Visit]","qryCallsCount") The qryCallsCount is a crosstab query that returns...

Ok, i need some big advice from you people i think. Let me explain: I have an append query that adds records to my main customer table from a temporary table. The temporary table contains the up-to-date customer info exported from my sales system. The records are appended if the customer...

I require more help from your lovely selfs please :) I have a form that has a combo box and a text box on it. The combo box looks up a list of customer names from a query, and the after update event automatically fills the text box with the customer number from that query. See below: Private...

Ok, here's the scenario for your lovely selfs: I have a form to add records. On this form is an "Add Record" button, that of course adds the record when the data is entered. 2 of the fields on this form (CompanyName and PostCode) are related to 2 fields in the main table that are indexed, so...

OK, i apologise if this has been asked before. I'm new this forum and couldn't find it anywhere. I am using a switchboard made with the Switchboard Manager, which has a second switchboard (SwitchboardID 2). I have buttons on the second switchboard that open up other forms, and then a button...