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

Thanks

Thanks for that, but could I just qualify the info you sent Left([MyField],2) Like "[A-Z]*" And Mid([MyField],3,2) Like "[0-9]*" I take it the first part, Left([MyField],2), looks at the first two parts of the field. Could you just explain what, Mid([MyField],3,2), looks at, ie what does the...

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

Cheers, Thats done the trick.

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

You could possibly convert the database file from a *.mdb to a *.mde file this will restrict what people can see behind the scenes. There is a tool in Tools/Database Utilities to do this. Hope this helps.

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've now got DCount working but it counts all the records in the underlying querry. How do I count just the records that are showing in my linked subform. Can I refer to a control on the form using the underlying querry as the domain?

Looking at the syntax for Dcount («expr», «domain», «criteria») I take it the <<expr>> would be the control on the suborm but what would the domain be ? bearing in mind I only want to count the records associated with the record selected on the first form and what do I do about the critera?

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?