Search results

I regulary import data from an excel sheet through a macro transfer spreadsheet, 99 % of the time without issue. I have one field that is a formatted both in excel and the access table as text. My problem is that out of 1000 records sometime this field will contain an alfa-nurmeric ie...

I have a report which is query based, it produces % share both in Text format and in a Pie Chart. My question is how can I restrict the data to only say the top 5 share with the balance being "others" I cannot get the text side to sort in decending or assending order or a way of limiting the...

Autonumber setting Thanks Pat I worked on my problem yesterday before I got your post and I was able to fix my problem in a backward way by: creating a copy table, appending from the original only data the with the correct auto numbers, then re-importing the bad number records and then renaming...

AutoNumber Setting Thanks I tried that and I can see it works for setting a new start autonumber but no on my problem unless I doing something wrong.

I have used an autonumber as my identifer for each record, the operators use this number for purchase orders etc. due to errors encountered whilst importing the auto number has jumped from 47896 yesterday to 37883539 today, whilst only 45 records were imported. my operators are complaining like...

Using Access / Excel 2k For almost 3 years we have been successfully importing from an excel file into access daily booking records (80-100) per day without any issue, sometimes if the data has been entered in excel wrong then we get errors. My problem is the source excel file has been changed...

Thanks for the reply, but I am setting the text box properties in the report fields, but no matter what format type it is set to it still appears as entered in the query select parmaters (I know if the selected was based on a from I could specify the format but I am just seeing if I can get...

I have a simple report based on a query with only the two selection using the parameters of Between [From Date] and [to Date] if the selection is entered as i.e. 1/7 to 30/7 I want these two date to appear in the report heading- no problem here but is there a simple way of making the format...

I know i could use an update but that would be just a quick as the way we currently do it, If I could just explain, each record is a delivery record, the final fields to complete the record are delivery date, time and name. Presently the delivery record is located by a normal an access find on...

Not sure if this is possible or how but: I want to update only a couple of fields on a job form date and time etc. and would like to be able to 1/ locate the full record then update only the selected fields. My thoughts are for an entry field which on exit? would do a find record according to...

Thats great and works a treat many thanks

Ok thanks, I though my ignorance I might be missing a simple existing function but I can see from your answers probably not! thanks Have a good day :D

thanks for your reply At present I only use the first part of dates i.e 1/3 to 31/3 which returns only the current years data I know at changes in year we use i.e 12/12/03 - 12/1/04 to avoid issues. thanks

I am running report on all activity in a given Month, currently I use From and To dates as the parameters but is there a way of selecting a whole month in a parameter without entering the from and to dates i.e. [March] instead of Between [From Date] (1/3/04) And [To Date] (31/3/04) any help please.

Thanks I went through the help last night and as you said I have now "seen the light" many thanks for your help Steve

There sould be no skipped milages so the Dmin Dmax functions you refer to sould like what I need, could you beifly explain them for thicko me thanks

I’m looking for some advise what I should do. I need to create a report on vehicle mileages. I have a daily table which data is collected in Veh, Date. Kms/Mile reading. I have a query which gets the data out by selected date range but I need to be able to use the first reading and last reading...

Many thanks for the lead, and yes it appears works fine for links to a single backend. But my FE links to two different BE's what I would like to do is to be able to link my FE to \my1_be.mbd link my FE to \my2_be.mbd once the backend has been copied to my PC and again to return the links to...

I quite often take backup copies of my FE and BE databases home to work on the FE. Because the BE resides on our server and the FE’s on individual PC’s. I need to re-link the tables. My question is can I automate this facility either by macro or code so I can run an update link i.e. when...

Thanks for that but no luck, it seems that Find / Replace built in does not like any functions in its find option?