Search results

Thanks for replying. Is there another method to produce a unique number per record added to the table?

Hello, I have a form where I'm entering new records. It has an Autonumber. My question is, If I undo or delete the current record, how can I make to Autonumber not to advance to the next number. Right now, when I delete or undo the record, it will advance one number. I just want the autonumber...

Hello, I need a query from a form that has several criterias. There will be 8 text boxes that will take the criteria but I don't even have an Idea from where to start. can someone help. All help will be greatelly appreciated.

Sorry for giving vague information. what I mean is convert a from to an Access Page. what I want is to access my database from a browser throw access pages. can it be done? thank you for your response.

Is it possible to convert forms to pages and keep their calculations and settings the same? Help will be appreciated.

Is it possible to make a Query from different databases. Can someone help. Thank you.

Thanks for all your help guys, it worked.

Thanks for your help. It worked.

thanks for the code, but the running Total is running fine. what I need to do is get the running total from the previous record and put it in the current record. can you help me with this. thanks

Thank you for responding. I tried it in a form, but does not work. this is what I tried: PreviousTTL: DLookUp("[runttl]","Cash Disbursment","[ID] = " & [ID]-1) and this: PreviousTTL: DLookUp("[moneyorder]+[cashin]-[cashout] +[atmin] -[loosecoin]-[mutesold]-[atmout]","Cash Disbursment","[ID] =...

Thank you for responding. I don't undestand what you mean about dir() function. I looked for this function but could not find anything. can you tell me how to implement the dir()funtion. Thanks

Hello, I'm running a report everyday when I open my project, the problem is that the project is opened more than once a day and I only want to run the report once a day. What I want to do is to check if the file already exist before running it again. can someone help me. All help will be...

Hello, I'm trying to run a query were I get the running total (runttl)from a calculated field and I want to get the running total (runttl)from the previous record and add it and display it in the current record. when I try this SELECT DLookUp("[runttl]","cash disbursment","[id]>=" & [id]-1) AS...

:confused: Hello, I'm trying to run a report once a day every first of the month when ever the database is open. My problem is that the database is opened more than once a day. How can I make the report just run once every month? Also, is there any way to export the report to a folder with the...

Hello, I'm trying to export a report with OUTPUTTO function with a VB but it gives me an error that goes like this:. Run-tim error '2024': The report snapshot was not created because you don't have enough free disk space for temporary work files. This is what I have: DoCmd.OutputTo...

this is what I'm using =IIf(DLookUp("[ddate]","[DD]","[ddate] = Forms![A]![dDate]"),MsgBox("Date is already in database, please enter a unique date.")) Can someone please help!!

Hello, I'm trying to verify that we get unique data from form "A" to table "DD". the field that Im checking is "DDdate". I'm trying dlookup but I dont really know how to use it. can someone help.

thank you, I installed service pack 3,4 & 5 and it worked with access 2000.

I'm writing a program in visual basic 6.0 and when I try to link the program to a ACCESS 2000 Database it gives me an error that says, URECOGNIZED DATABASE FORMAT followed by the path of the access database. Can someone Please HELP ME!. All help will be appreciated. thanks

table = cash disbursment id = auto number I want to get a running total out of subtotal, but I keep getting an error when I try to run it, the error: CAN NOT GROUP ON FIELDS SELECTED WITH '*'. SELECT [cash disbursment].id AS idalias, Sum([cash disbursment].SubTotal) AS SumOfSubTotal...