Search results

Sorry completely my fault, as i was tryin to do this for you and do something else... the correct code is Dim Value1, Value2 Value1 = [PriceBook_OLD.Cost] Select Case Value1 Case Is <= 5 Value2 = Value1 * 3.8 Case Is > 5 And Value1 <= 50 Value2 = Value1 * 3.2 Case Is > 50 And Value1...

I hope this helps, and i have done all the symbols correct, it not let me know. I would put this in the after_update procedure of the fields that you need to query, which is this example would be Value1 Any issue let me know. Dim Value1, Value2 Value1 = [value that you are querying]...

why do you feel you can not use this method????

I have had something similar, but not as wierd as yours. But i solved my issue by looking in the autocorrect options, everytime a typed something it always changed it, that got me confused, and this solved it. I just hope this may work for you, let me know if it does or doesn't....

are you using this on form to autmatically update a field, if so then a select case would be the best procedure to use!! If you are unsure how to write a select case then let me know.

go into the regional settings in control panel, then click on customize, then click on the data tab, look at the short date format, i use dd/MM/yy. I know there were some issue with queries when changing them from 2000 to newer version, what i would suggest is creating a new query, using your...

have you changed the version of access!!! in your computer settings is your date format the same as the old 98 computer, you may want to double check this as sometime i forget to chanmge mine from US to UK, and it does cause issues. Does the database still run on other pc within your office...

You have used True in your query, so what you are trying to say is that the check box is ticked. You actually need to put -1, as -1 = True, and 0 = False I hope this helps.

why isn't all 5 users linked to the same database file located on the server, this way you would not need to update the master file each day. but what you could have is a backup procedure instead...

have you tried exporting a report to a PDF, you can edit it, and if you have graphics in the report then you will also see these. Or an alternative from access is to use Crystal report. When yo export/save a report to a RTF file then instead where access re-formats the text, crystal puts...

Yes it is possible. I beleive there is 2 ways either you can keep the access program running and then use the timer interval on a form to trigger an event to export the reports. Or you could use the windows scheduling to open up the access file, which in turn triggers an event to export the...

your first point i do not know how to do, but your second point the way around this would be to put the procedure into a form on_close procedure. But the best form to put this in is the form that loads up first, so a menu form. So even if they exit access via another way this form has still...

if you can do it in smaller files then this would be better. What i would do is to try a 20-50mb file first and to make sure this imports, then try a 100mb file. It may be the size of the text file, or some data that due being a text file it has corrupted it some how. Have you tried linking...

another idea, where did this text file come from, could you go back and get it in another format, or the text file may be corrupt!!!!

can you open the file up in excel!!!!! and convert to to a xls file instead!!! Since the file is so large i'm unsure if this would be possible though. I would say send me the excel file, but again this would be an issue due to the size. So you can link it, can you actually open the table...

when you open the form up without going through the open form procedure, can you add data into the subform?? If not then there is something wrong with you relationship between the 2 forms.

could you convert the db to A97 for me please. Quite a simple query really, it should not take me long.

you can do a query to select 100 records, but is there a criteria for this 100 records. To select 100 records in a query, go into the design view, right click in the top part where the tables/queries are shown, and select properties. In here there is an option for TOP values, change this to...

have you tried linking to the text file instead, and seeing if you are able to open it up then. If you are able to do it this way then create a query to make a new table from the linked text file. I hope this makes sense, any more issue please let me know.

sorry my fault, I forgot you said subform. Use the following Me.SUBFORM_NAME!txtsubtotal.Requery It should work now, sorry about that trying to do more than one thing at a time...