Search results for query: *

Hi all I am trying to test wether or not a form is 'dirty'. ie wether or not changes have been made. From there i ask the user if they would like the changes to be saved. Below is the code i use but I keep getting an error message "You entered an expression that has an invalid referance...

Hi all I have an application circa 1991. The interface is very basic and the only way you can extract records is to print them out. There is thousands. I have managed to locate two files called streets.db and dispmis5.db. I am assuming these files contain the data i need. I have tried...

Hi I want to run a query from VBA code and detect if it returns a record. So all i want to know is Yes it does return a record or No it doesnt return a record. Is this possible? cheers wah

Hi I have a form with required fields. When the user quits the database and hasn't filled in all required fields an error is generated, but the option to quit is still there. If the user ignores the warning and quits that record will be lost. The warning that is given is to long-winded for...

Hi everyone I have a text box on a form and the source control is a memo field. Problem is the text box will only display the first 255 characters of the memo field. Is there a way to get around this? Thanks in advance ben

Hi everyone I have a text box on a form and the source control is a memo field. Problem is the text box will only display the first 255 characters of the memo field. Is there a way to get around this? Thanks in advance ben

Hi all Does anyone know of an axtive X control that would display a color pallete (similar to Color Builder) so that the user can choose a color on the fly? At the moment I have the user enter the number code into a text box to change color properties but that isnt very user friendly...

Hi The problem I am having is when I use the parameter passed by the function as a control name. Any ideas? Public Function EmpAgeCheckRed(txtField As Control) Dim RedColor As Long RedColor = RGB(255, 0, 0) Me![txtField].BorderColor = RedColor End Function...

Gday Gday I have a list box on a form and when the user selects a value from that list box (AppraisalID), the text box next to it will display the associated details (AppraisalDetails). Thats how I would like it to happen in theory but am having trouble getting it to work! The form is based...

Hi all Access 97 and my Receipt printer have conflicts so what i need to do is send a command to the printer using a font called Control. The printer detects this char of font Control (in this case 'A') and performs the action. It works fine in Word, wordpad etc but Access does not list that...

Hi I have a database and all that is required is the user to fill in a simple form. The form has required fields that need to be completed before they can navigate, quit, add new record etc. A message will pop up telling them why they cant do any of the before mentioned commands if they try...

Hi all I have a form with required fields. I also have a quit button that exits out of Access completly. Problem is if one of these required fields isnt filled out and the user wants to quit not caring if they loose the information, access gives them an error message they dont understand. I...

I have an MS Access 97 database running on a Win2000 based PCs with Star SP300 Receipt printers and associated Star Till Draw. The problem I am having is when a receipt (Report) is printed the till drawer wont pop open. Previously the system was running on Windows 98 and I had the same problem...

Hi I am using Access 97. I have a report based upon a query that grabs all the records whose car registration number occures more than once in the db. What i want to do is change text color so the first lot of duplicates are black, next is red, then next is black etc. for example: XCV12PL...

Hi I have made an Access 97 db and one of the fields is 'carRego'. I want to grab the records of those whos carRego occurs nore than once in the db. any ideas for a query? ta in advance wah

Hi All I am using Access 97 to print a receipt to a Star sp312 receipt printer connected to a cash draw. When the printer recieves a print job it automatically pops the cash draw. Problem is when i design a receipt as a report in Access it doesnt!! However if i design the receipt as a form...

Hi I have created a new db that has just a form. On the form there will be command buttons that will open up applications the employees here use. At the moment I am trying to open another database but keep getting the error "Invalid procedure call or argument". Here is my code for the...

Hi I have a report that lists a series of numbers. Due to a problem that i wont go into here, i have had to convert those numbers to strings before placing them on the report. Now i have a new problem! It orders the numbers by the first digit. Thus i get something like: 1 10 11 12 13 3 33 4 41...

Hi I am using a query in Access 97 to select postcodes that begin with a particular combination (eg UB1, UB2 W5, W6 etc). The user, via a form, selects which combo it will be. How will the SQL code look? This is what i have at the moment but it is obviously wrong... SELECT DPPF.refnum FROM DPPF...

Hi I am using a query to select postcodes that begin with a particular combination (eg UB1, UB2 W5, W6 etc). The user, via a form, selects which combo it will be. How will the SQL code look? This is what i have at the moment but it is obviously wrong... SELECT DPPF.refnum FROM DPPF WHERE...