Search results

Hi there, You declare your public variables in a seperate module. At the database window, select the modules tab and click 'New' to take you to the VB environment. Declare your public variables in here then you can pass values to them from your sub-procedures in your forms. Does that answer...

This could be a mapping problem. Have you checked your network to make sure you're still mapped on the same drive letter and that it connects OK to the network?

Can you give me some more details like what it is you've done so far and what expression you are trying to do. Rob

Hi there, Well your part way there by adding a check box field which only you can edit. Once you have that you can browse the database using a form and can either display the non ratified records where your check box = False i.e. no tick or you can display all and use some code to test the...

Hi Assuming your lookup table has a field that identifies each record as a glass code or mirror code etc. e.g. may be a category field, you'll need to set the criteria in the underlying the row source of your combo box

No problemo ;) :D If you need more help just post again

Hi TheB If you have a scenario whereby you have a report based on no criteria or on all of the criteria then I would suggest the following: 1. Create the report / query as in my previous post. This report will be the one that requires all the criteria from your parameters form. We'll call it...

Hi Rich, Yes that would work. Presumaby the best method to use would be the DCount function? Basically the user selects from a form what job they want to print on then the JobNumber value is passed to the underlying query of the report. So on that basis in the reports On_Open event I presume...

Hi there, OK on your paramters form will you need to perform a selection on all of the criteria or just some of them?

Hi all, I have a form which allows the user to choose the criteria and select what type of report he/she wants to print. One of these reports that can be printed is a job transaction list which basically shows the purchase orders booked to a job and the transactions on each order. This means...

Hi TheB, Ok first create your form that will display all the text boxes needed for your users to enter the required parameters. These text boxes can remain unbound i.e. they don't need to be linked to an underlying field on your tables. Secondly create your query and include all the fields you...

In the properties of your combo box, go to the rowsource and click the build button. This should take you to the the query screen that builds the SQL behind the combo box. Just sort on the required field. HTH Rob

Hi RichM Thanks for your reply. Sorry for sounding a bit vague but yeah your right, I did use a function to return the value etc. I suddenly remembered how to do it late last night :cool: Yesterday was just one of those days :rolleyes: Anyway I've got it to do what I wanted so thanks for...

Hi all, I have a public variable (pubJobNoID) that contains a JobNoID value for a job which is of variant data type. I also have a combo box that list all the available jobs which is bound to the JobNoID field Please can someone remind me what the code is for looping through the combo box and...

Just to throw another idea into the pot... Why not have a form with 2 subforms. On the main form place your calendar and when you select the date set the record source of the first subform to your query. Then in the second subform you can display the whole details by selecting the record in the...

You need to use the On_Error event of your form. Alternatively you can trap the error in the Before_Update event as well by adding a GoTo statement: On Error GoTo ErrorTrap: Your update code here ErrorTrap: Your ErrorTrap code here HTH Rob

Thanks Rich :) Why didn't I think of that in the first place :rolleyes:

Hi all, How do I go about displaying text in the statusbar? Basically I have a form with subform which allows the user to record their times against different jobs (frmTimesheet & frmTimesheetDetailsSubform). In the subform the user selects the job they have been working on from a combo box...

Hi there, I've just tried out this piece of code in Access 2K Private Sub txtAreaCode_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeySpace Then txtNumber.SetFocus End If End Sub Where I have txtAreaCode and txtNumber just substitute for the name of your controls. HTH Rob

Hi Craig, Ok to answer your posts: Go to the relationship window, right click on the relationship line and select 'Delete'. Again go to the relationship window and right click on the relationship line. Select 'Edit the Relationship' and this displays the dialogue box on screen. Put a tick...