Search results

That worked perfectly jzwp22! Thank you very much. I've never been able to get to grips with the use of variables and double quotes. I kind of just bumble along through it (going on a course soon though). And I didn't realise EXISTS was a keyword. That is now changed :) Again, thank you very...

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 Boyd, Thank you very much for your suggestion, but i still cant get it to work. I'm still getting the #NAME error. Is the IsError function only available in Access 2007 (i'm using 2000), as the IfError is only available in Excel 2007? If so, is there a workaround? If not, any clue what i'm...

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

Thank you all very much for your suggestions. I'm going to play around with each of them and see which works best. You've definately got me in the right direction :)

That is part of my problem :) The only workaround i can think of (but don't know how to implement) is to have an alert if either the postcode OR company name already exist, and if there is more than one instance of the same postcode, which is very likely, show them all and have the option to...

Can anybody help me with this please? Any suggestion or point in the right direction would be much appreciated. Thank you :)

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

Thank you very much Paul, that works perfect!

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

Sir, you are a genius!! That works perfectly. Thank you! I now have it that if there is a duplicate (using your very helpful suggestion), i get an error message saying that the comination exists. And if there is any other error, such as a required field is not entered, the message shows...

Hi Paul Thank you very much for your response, but i still don't understand. Like i said, i am very new to this. I tried implementing the dcount function, but wasn't entirely sure if it was working (I was just getting the same error message whether i was trying to add a duplicate or not)...

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

Cheers Poppa Smurf. The idea of simply hiding the switchboard never occured to me. I have it set so that it closes completely when a form is opened, and then reopened when the form is closed. I have actually managed to find a solution that does the job just as well (see above), but i'm sure...

For those interested, i found it! Private Sub cmdOpenSwitchboard_Click() On Error GoTo ErrorPoint DoCmd.OpenForm "Switchboard" Forms!Switchboard.Filter = "[ItemNumber] = 0 " _ & "And [SwitchboardID] = 2" Forms!Switchboard.Refresh ExitPoint: Exit Sub ErrorPoint: MsgBox "The following...

I still haven't found a solution to this problem. I have done extensive google searching, looked through numerous Access manuals, and still nothing. I really dont want to have to create new forms from scratch instead of using the built in switchboard because my database is almost complete. I'm...

Hi Dave, I should have mentioned, i have it set so that when the user opens a form from the switchboard, the switchboard automatically closes. I only want the users to be able to use one screen at a time, hence why I then have buttons on the forms that re-open the switchboard. The problem is...

Just in case my question didn't make sense, this is the bit of code i believe needs altering. Private Sub Command12_Click() On Error GoTo Err_Command12_Click Dim stDocName As String Dim stLinkCriteria As String DoCmd.Close stDocName = "Switchboard" DoCmd.OpenForm stDocName, , , stLinkCriteria...

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