Search results

I have a data base that contains details of vehicles, what I would like to do is store a scanned image of the vehicle registration document that can be recalled when the particular car is selected from the data base.

I have a querry call AccountCheck and it contains 4 fields, 2 of which contain account numbers. The fields containing the account numbers are called PSAcc and MKAcc What I would like to do is only show the records where the values in the account number fields are unmatched in each record. I...

How can you set the criteria in a querry to look for all data that starts with two letters then two numbers

Have a table that carrys details of vehicles and want to create a querry that just sorts out the Fords. The problem is the word Ford can be found anywhere in the vehicles description. Is there a way of just looking for a certain string ie Ford, that can be requested in the criteria of the...

Trying to pass a date to an empty field on a form when a completed check boc is ticked. I am using Me.completedon = Now() but I also get the time, how can I pass just the date??? Thanks

Can anyone help I have the follow bit of code and kep getting the Complile error Else without If Private Sub completed_Click() If IsNull(Me.followedupby.Value) = True Then MsgBox "Select Operator" GoTo 1 1 Me.completed = 0 Else Me.completedon = Now() End If

I have a linked table that is in comma delimitted format, the problem I am having is that the date fields in the linked table have date fields that are empty which are shown as --/--/----. To make the linked table work I have the properties of the date field set as text, but this causes a...

I have a form which is based on a querry, all the formats for the fields in both the querry and form are set to fixed ie. 2 decimal places. My problem is when I select a field in the form the number loses its format and showes many more than the 2 decimal places wanted. Any ideas????

My start up form has a lot to do when it first loads. How can I stop the database window showinging the form untill it is completly loaded, so no one can see the form building up?

I want to be able to change the caption on a command button to a text value from a table. My database has several command buttons, each one representing a technician in a work shop. All their names are stored in a table. I would like to look up their names and change the caption on the command...

I have a form that has two subforms linked together that are in datasheet view, when the first sub form is selected it shows the records related to it in the second subform. Is there a way of counting the records in the second subform and showing them as a numeric value on the main form, i've...

I have a data sheet form and would like to be able to change the field names shown across the top of the from, the values for the headings coming from a table. Is is possible to acheive in VBA when the form loads.

I am trying to use the Active X control that shows a range of dates that you can choose from. I have an unbound box that I want the date choosen from the date control to show. My prblem is the first time I choose a date it works fine but if I change the date it does not update the unbound box...

Is it possible to have the datasheet run across the page, left to right, rather than down the page?

Is it possible to change the data source of a form by the clicking a button on the form. ie. have 2 querries that show differnt ranges of records that can be switched between while the form is still open

Is there a way of showing a calander that a date can be choosen from. A little like the calanders in Outlook down the right hand side.

Would like to be able to change the colour of text in a field based upon its value (ie. negative in red and positive in black)without affect the same field in other records on the datasheet. Each time I try it it changes the field in all of the records. The field is a calculated field not bound...