Search results

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

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 guys, Well I've been searching through the forums trying to find an answer / help with my problem but I've just ended up confusing myself :( Hopefully someone can help me out and I apologise in advance if similar posts have been made before :D Basically I'm trying to send a standard...

Hi everyone I have a database that records purchase orders. The orders can be raised in one of 3 currencies - Sterling, Euros & US Dollars. The underlying field has been set to a general number and NOT currency as I have a seperate field (combo box) that denotes the currency. Now a user can...

Well here's a weird one! I have lots of reports in my database which all work fine no problem at all. I have a custom tool bar for the reports and one of those runs a macro which displays the page setup dialog box. I've been working on a report which when previewed displays correctly on the...

Hi guys I have a bit of a problem which I hope someone can help me out with. I have a main form (frmGoodsReceived) and a subform (frmGoodsReceivedDetailsSubform) both linked on OrderID. Basically this form allows the user to select an order, load the details of that order into the subform and...

Good morning all I have a database which uses a custom built menu and not any of the Access standard menus. When a user starts up the database he/she is required to login with a username and password. When logged in the permission level for the user is retrieved from the table and stored in a...

OK here's an interesting one I have a combo box on a form which queries a table called tblEmployees. Basically it displays a list of employee names. Now this list is in no order so it displays names as they are listed in the table. In the table itself I have the field 'Name' which contains the...

I have a database that is split into a FE and BE. The BE resides on a server without any restrictions i.e. open access and I have coded some simple security into the FE to restrict user access to certain forms and reports. In the next few weeks I plan to add some more functionality to this...

I have an annoying problem that I can't seem to solve and I'll probably kick myself when I find out how simple the solution is!! I have a form with a subform - frmNewAssetRecord and frmNewAssetRecordSubform. When the form loads all the controls on the subform are disabled. The user has to enter...

I have a database that's split i.e the back end .mdb residing on a server and the front end on each users PC. Therefore the front end .mdb uses a mapped network drive for the path to the back end .mdb - in my case S: Now if the user changes the mapped network drive for whatever reason then...

I'm sure this has been asked before but does anyone have any ideas on how to code a module that detects the screen size of a user's PC? Because I have several user's all with different screen sizes it's a real pain to adjust the form view and column sizes to each pc. What I would like to do (if...