Search results

Hi I am trying to open a form that has 3 tabs on it. Each tab has a differant form. When I click the link on the main form, I would like the selected form to open and the Tabs to change to the selected subform. Link1>Form with Subforms>Tab 2 is open Link2>Form with Subforms>Tab 3 is open...

That worked a treat on most of the forms. Thanks. The only form I can't get it to work on is one that has to open in DS view. If I set this form like so: DoCmd.OpenForm "frm_reps", acFormDS, , , acFormReadOnly It opens in standard form view. This is no good as the form opens a second form...

I have just re-tested the code and it worked when I put it in the switchboard code and not in a module on its own. I have even got it working on a simple text link which was not working at the begining. Thank you very much for your code and your support. I now have a list of codes that...

Hi mhartman I tried the code and i cant get it to work. here is the code in the new module I created. I then created a link to it and named it cmdCloseOpen as you said. When I click the link it brings me back to the module window and the code is highlighted on the first form...

Hi I am trying to get access to close all open forms and open the selected form when a button is pressed. I tried this in a macro like so: open switchboard open new.client close (forms) The switchboard is used as a back drop to the database. the new client form will open over this (pop up...

I hope someone can help me. I have a form in my access 2003 database that I want to use for displaying small tables that would change at the click of a button. I want to use one form but when a person clicks on a button on the main form the table being shown changes to the selection the use...

Can this form be displayed in table view and accessed as such. Its quite important that they see more then one record at the same time.

I am not sure if this has been done in a table before. I have seen it in forms but not in tables. Here is my problem. I have created a database for a planespotters club. This database has the tables. ac_logged ac_maker ac_model country airport I am trying to display selected information in...

All the text boxes are flush with one and other. I also have a lot of space to spare around the outside of the information. If I reduce the space around the labels then they are all misaligned.

I am having problems printing labels in my Access 2003 database. The setting’s I have selected is L7161 and J8161. Both labels settings are missing the last row of labels. I have tried resizing the font to 8pt and changing the border size but nothing seems to work. I have a lot of L7161...

I am trying to build a table that lists aircraft viewed by plane spotters. In the “aircraft_spotted” table I have two look up wizards. The first lists the make of aircraft and the second lists the type. What I am trying to do is filter the models down to the maker. If I select Boeing I will...

Thanks Col Worked perfect

Tried that with no joy. I have iif([mem_free]="yes","F","P") It won't pick up the information and all records are printing P

I am trying to get a label report to print out a (P) or (F) on a label biased on the criteria True or False. I have a database that print’s labels for members in a club. Most members are paying members but there are some members that are free for a number of reasons. We need to identify the...

Hi Ian Having a bit of a problem with the SQL as it already as a GROUP BY Field. Here is the code SELECT [Batch Qry].ba_id, [Batch Qry].ba_date, [Batch Qry].pap_computerRef, IIf([Batch Qry]!ba_actul_lenght>5999,1) AS [Reel 1 used], [Batch Qry].pap_computerRef2, IIf([ba_actul_lenght2]>5999,1) AS...

Thanks Ian I will get back to you when I give it a try.

I am running an export Query but I need to count records and total there qty cell values. Its hard to explain what I mean so have a look below This is what I have Product QTY Paper 1 20 Paper 1 14 Paper 2 5 Paper 3 3 Paper 3 7 This is what I would like to happen...

Thanks for that. It now works the way I want.

I have tried this to no avail. I get a message "Type mismatch" Here is the code. Private Sub calculate_Click() On Error GoTo Err_calculate_Click Dim stDocName As String Dim stLinkCriteria As String DoCmd.Save stDocName = "calculate" DoCmd.Save "Batch Costing" stLinkCriteria...

I hope someone can help. I have a form that is based on a table and a second form that is based on a query. On the first form the person will enter information such as paper lenght and box's produced. When they click a button "Calculate" It takes them to a second form that will display the...