Search results

I have an Access database with related tables and lookups. The data for the tables is in a large Excel file with about 100 columns and 30,000+ records, which will be imported into one flat Access table. This table has to be imported into smaller related tables. Each record contains all the data...

I am writing an Access 2010 program for a small business. They want the ability to track the actvity logs of users: if they added, deleted or edited. Is there a capabilty to do this in Access? I knw there is a macro that could be set to show the most recent user, but I don't think it could...

I am trying to use Dcount to find the number of records in a query and put it on a text box in the header of a report. The query is a parameter query. The button opens a form which asks for start and end dates, the query reads those dates from the form and the report displays the correct number...

I can't get a date field to display the month andyear. In the form format box, I worote mm/yy. when i type that in the form it interprets 8/15 as august 15 2013 instead of August 2015. this should not by hard. Thank you to all of you for your wonderful answers! Access 2010 win 7 jojo

I have a form that accepts credit card information. The user wants this to open with a button that asks for a password so that only those with the correct password can use the form. I am sure this is something pretty simple, but is eluding me. Access 2010, windows 7 Thakns for any help, and...

This is a very general question, and any insights would be appreciated. My work venue has changed, and I working for someone who has clients, and needs an Access database (A 2010). My boss wants a proposal stating what has to be done, and how much it will cost. I do not know how to make a...

I have a an unbound form with 3 text boxes which I created as a modal dialog form, and I'm pretty sure that's waht I need. The user will enter text into 3 text boxes (and one of them should really be a combo box) and the main form based on the data table should open displaying only the records...

I have a nasty bug on a form, and would be grateful for help. The last field on the form is a combo box. When the user enters data, and presses tab or enter, it goes right to a new blank record with focus on first blank field ready to enter new data. BUT if instead she goes to a different...

I have a form with a tab control and need to cut some controls out of the tab control and put them on the form. Is there a way to do that so that the associated events move with the controls? Access 2010 Thank you very much. Jojo

I'm sure this is a simple one. I have a button on a form that calls a macro. The macro only has to print a roport of some fields on this current record. The report of the macro works. In the macro, the OpenReport where condition is =Id = [currentrecord]. Id is the autonumber, primary key...

I wonder if anyone can supply the code to open a simple access 2010 report in Word to PREVIEW, using a command button. Thank you and thanks to all the responders of this great forum! Jojo

thank you to all of you for this great site! I have a report that's based on a parameter query using a start date and end date. If the user enters 9/8 when prompted for the date, the query works but they want the year to be required ie 9/5/2012. It works without typing in the year, using...

In Access 2010, i have a form that calls a form for data entry and it opens to a new record for data entery. I have put some default dates and a combo box value into the properties on the form. When the form opens, it already has an autonumber, so if the user closes without adding any fields...

I have menu form with a button to open the data entry form to a new, blank record. The record displays with the fields blank, but with the defaults filled in, and with the autonumber incremented. If the user then decides not to do any work, but closes by clicking the X that new record is...

In Access 2010, have a form with a comand button that goes thru a range of recs and checks a field to see if that rec should be deleted. I had an identical button in an old system I wrote using Access 2002, so I copied the code but it just keeps going past the end of the records and adds new...

I am working on a macro that should check to see if a field is blank, then close that form without saving the rec, and open another form. The field is text. The if statement has the full reference of forms!form name! etc, but i typed if [field] <>" ", and i'm getting a data mismatch error...

I have a combo box on a form, and the control source is created by the query builder. When the user selects a value from the drop-down, I need text box elsewhere on the form to display a different field of the same record in the same query. This table was designed (not by me) with just the...

I am an Access newbie. I have a form with a command button that displays a report in print preview and a message box that asks the user if he wants to print now. If he clicks vbOK, the printdialog box displays, but if he cancels out of that, he should be able to preview the form to see if he...

hello all, I'm new to forum and pretty new to access. My question seems simple. What events are triggered by the forward and backward record selector keys? and by the new record key? On CHange? After Update? thank you jojo