Search results

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.

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.

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

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.

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 CAN NOT GROUP ON FIELDS SELECTED WITH '*'. I want to get a running total out of subtotal, but I keep getting an error when I try to run it, the error: SELECT [cash disbursment].id AS idalias, Sum([cash disbursment].SubTotal) AS SumOfSubTotal...

Is there a way of making a query to go to the last record of a table and get data from a field and copy it to a different field in a form??? All help will be appreciated.

I have a form that has a previousBalance, subtotal and a total text boxes linked to a table. the previousbalance has to be yesterday's subtotal when I Input a new record, and todays subtotal will be tomorrows previousbalance. Is there a way to do that?? all help will be appreciated. thanks

i have a form with textboxes that are linked to a table. my problem is that when I click on the previous record and when I get out of the form it automatically saves the record to the table. if I put the date as the index key it will give me an error that it cannot save changes that I made...

I created a report from a query, I need that report to be exported somewhere where users would not need Access to view report. If possible to keep all formats of report. all help will be appreciated

I have a form from where I get the criteria to a query. two textboxes will be dates (ex. 12/12/01). one for the beggining date of the query and the other one for the end date of the query. I also have more textboxes that also affect the query result, but that is currency. my problem is that when...