Search results

Thanks for the replies I'll just try and explain this a bit better: Paper application forms are logged into my system. The main table holds information about the app including date received, who took the app, where it was taken etc. If the applications have any problems with them, these...

Please! Anyone?

OK, thanks

I want to run an event if the column value for a combo is 27 or 39 or 40 etc. I've tried the following but it doesn't work. Could someone point me in the right direction? If Me.cmbAppCriteria1.Column(0) = "27" Or "39" Or "40" Or "48" Then

Thanks mate! That does the job thanks :)

Just adding DB in Access 97 format!

I need help in designing a query. Application forms are logged into my system. Some of the apps will have errors on them so these are logged into the tblApplicationErrors table. Most common errors are missing postcode, illegible name etc I have two tables that have a one to one relationship...

Thanks, Thats the one I used :)

Cheers m8, SelStart = 0 for the very start :)

One of my form fileds has an input mask of 00/00/0000. The problem is when somebody clicks on the field and tries to type the date into the month part because thats where they clicked What VB code do I use to make the blinking cursor move to the start of the field? Cheerio

Jaysus m8, thats fantastic. Ill examine the workings of it now

MIle, I have now designed an 'Assignments' table as recommended. SalesExecID | VenueID ----------------------------- 1 | 3 1 | 7 1 | 9 2 | 2 2 | 4 2 | 8 3 | 4 3 | 7 3 | 8 Could you elaborate on the composite key and junction table?

OK Mile, I see what you mean. I will redesign the table now

I have a drop down list of Sales Executives names and below that is another dropdown list for different cities. I have a problem with my form where people choose the SalesExec and then accidentally choose the wrong city from the dropdown. I want the user to choose the SalesExec and then the...

I having a problem with my PivotChart. Instead of the chart displaying the SalesExec name and Country name it only diplays the lookup ID of the names. I have a book on access that mentions the problem but doesn't explain how to resolve it. Can somebody point me in the right direction...

SELECT tblSalesExec.EmployeeID, "Forename"+', '+"Surname" FROM tblSalesExec ORDER BY Forename; is the correct answer

Thanks friend, that really helps :)

^ bump

Just a quick one I run querys in Access that throw back some fancy pivot charts. Is it possible to have this as a web based facility eg. Data Access Pages?

Absolutley perfect! :cool: Thanks