Search results

I’m not sure if I’m posting this in the right area but here goes. I use find and replace to update many 10s of records with some basic items I need to update a date field from a blank record but I cannot seem to specify it in the find and replace options the blank / empty date fields. If I...

Managed to sort it but thanks anyway

I have a report formatted into a label, I wish to print this onto A4 portrait label paper with two A5 labels per page. I can produce 1 A5 label ok, but what do I do to enable two lables on 1 A4 size paper as when the 1st label prints out the paper is ejected and the next loaded. Ive scanned...

File Lock The FE and the BE are both on the server and user access the FE via a shortcut.

Locked Record All on access 2000, It is a FE / BE but the FE resides on the server and is accessed only by 3 - 4 users at any one time, There are no other combinations that have the same problem as I am aware. Steve

I have a DB which I have an irriating problem with. I have one user who locks the DB I cannot find any setting to be different on his machine but, when another user is adding records and has completed the system reports back that it cannot save the record. If I take the offending user machine...

Thanks very much works a treat now. Steve

I have a form open which I setvalue for 4 fields via a macro according to which [customer] is selected from a combo box. I use the onexit event to start my macro. The condition is as below: [Forms]![ExportsSheet]![Customer]="Dell Returns" Or "CIM (WW UK)" Or "ZZZ NON CHARGE" Or "Dell Bulk" Or "...

Ok thanks for that, I'll have a re-think regards

Sorry I'll explain, The main form is mainly data entry and shows only the current record, the sub form is positioned along the right side of the screen and is in datasheet view listing all the records for the date on the main form. I wish the user to be able to with the double click event etc to...

I have a sub form on my main form, this subform reports all the bookings equal to the date on the main record form (Child and master fields are linked by the date). I would like to be able to select a record in the subform and in so doing the main form record would now reflect the chosen record...

When I run Report via a parameter query I want the user input dates to be only of the dd/mm/yyyy format ie [From Date] to [To Date] but even though I have set both of these to the correct format and mask I am still able to enter a date as dd/mm where I am going wrong or can this only be...

Thanks for your help, I have discovered what was happening. During the import sequence some date fields were blank which is ok as long as they are Null, but they had a space in them this the import was failing because text was trying to import into a date field.

I regulary import from excel a large amount of data through a defined macro, this has worked very well until recently but I now keep getting an error stopping the marco completing "Numeric field overflow" I cannot find any reason for this. if a copy a row of data from excel I can pase it into...

Thanks for the reply but do you mean to base the form or the control on a query as the form has many other elements

Dlookup I have tried several verision but this is the expression I am using, but the value in my form is just blank, could you advise where you think I am going wrong =DLookUp("[ExchRate]","[Settings]","[ExchRate] = Forms![ExportsSheet]![Exch]") I have also tried...

Could anyone help with the methord of pulling a setting from one table and using it. I have a form which used data from several tables. I have a [settings] table which holds vat rates and exch rates etc and I need to be able to get the exch rate from [settings].[exch] and use it in...

Thanks for your help here, I understand in principal what your saying but not in practice could you expand a little please thanks

Thanks for that but I,m not sure just what you mean. Does the call automaticly increment a value each time the mde file is created i.e 0001234 , 5, 6 etc

I make many small changes to the DB as user may request (mde f/b split table), is there a way I can put an automatic verision number onto my menu form so I can readily check that it is the latest verison any help appriciated Steve