Search results for query: *

I need you help! I need to install Win98 on Dell notebook. It currently has no OS and a Safeboot program. This program is fine, except it gives me the option of either booting to OS (can't change) or Floppy. It has interchangable floppy and cd-rom drive in one bay. I have a problem when I use...

I am using the following code in a forms On_Error event. I works fine but I would like to set focus back to a specified control upon this error. Can anyone help me with this as I am not sure where to place the extra code needed. Thanks :-9 Private Sub Form_Error(DataErr As Integer...

I use the following code to change the access error message for duplicate key values. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3022 Then MsgBox "The Label Code you entered is already in use. Please select another code." Response =...

I use the following code to change the access error message for duplicate key values. Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr = 3022 Then MsgBox "The Label Code you entered is already in use. Please select another code." Response =...

I am trying to replicate the backend of a split db. When I run "Create Replica" I am given an error along the lines of "cannot convert because......cannot makeMSysCmdbars object in Tables container replicable". Now I know that you cannot replicate system tables, so why am I...

I need to create an update qry to change a text string form lower case, to beginning with an Upper case letter. e.g Change the brown cow to The brown cow Can anybody help? I would like to use query builder. B-)

I would like a control in my data entry form to check for duplicate values in it's bound table. If there is a duplicate value, I would like to prompt with a msg and return focus to that control, else continue to next control. Does anybody have any code that can help me achieve this! Thanks B-)

I have designed a label printing application that prints stored labels for pharmacy items. All works fine except I am using a true-type font at the moment and this causes the dot-matrix printer (Epson) to print as bitmaps, which are blurred. The solution would be to use a printer font, but the...

I have designed a label printing application that prints stored labels for pharmacy items. All works fine except I am using a true-type font at the moment and this causes the dot-matrix printer (Epson) to print as bitmaps, which are blurred. The solution would be to use a printer font, but the...

I have inadvertantly edited one of my standard built-in toolbars (Tools from Database Menubar). I have tried running Office Setup to restore setting but no success. Is there a way to restore this, within the Registry say? Any help would be appreciated B-)

Is it possible to show a bitmap pic on startup in Access 2000? I used to be able to show a bitmap with the same filename as the db in Access 97 while you had the PW dialog showing for a secured db, and this replaced the Access 97 startup pic. In Access 2000, the access window now opens...

I am receiving an error message "You can't import, export, create, modify or rename any forms, reports or modules in an .MDE database" In occurs (as far as I am aware) when I use the SetValue function to change a date value (now()) and update some other controls. Has anyone had any...

I am using the following code to concantenate one field from all records from the recordset, spaced with a comma. Dim db As Database Dim rs As Recordset Dim strName As String Dim intCnt As Integer Set db = CurrentDb Set rs = db.OpenRecordset("SELECT * FROM qryDrugItemString")...

I am using the following code to concantenate one field from all records from the recordset, spaced with a comma. Dim db As Database Dim rs As Recordset Dim strName As String Dim intCnt As Integer Set db = CurrentDb Set rs = db.OpenRecordset("SELECT * FROM qryDrugItemString")...

I am having a problem and getting a headache!!! I would like to concantenate all of the records from one field which have related records in two other fields. e.g. tblCars fldCarID fldCarName fldFuel fldWheels 1 BMW Petrol 4 2...

I am having a problem and getting a headache!!! I would like to concantenate all of the records from one field which have related records in two other fields. e.g. tblCars fldCarID fldCarName fldFuel fldWheels 1 BMW Petrol 4 2...

An earlier reply from Craig0201 helped with my problem but I am having a problem with the correct syntax for the SQL query. Basically I would like to concantenate all of the records from one field which have related records in two other fields. e.g. tblCars fldCarID fldCarName fldFuel...

I need to create a string showing all records from one field in a table. For example: In a table - tblCars with fields - fldCarID, fldCarName I wish to show all car names seperated with ", " in a control. Any help is much appreciated. B-)