Search results

Hi, I have a checkbox on a form (chk_Live) I have a field in a table that is also boolean (MD_Live) If the user ticks chk_Live i want to show only records where MD_Live = TRUE However if they leave un-ticked i want to show ALL records. Under the MD_Live field, i tried this :-...

Hi, I have a form with a tab control within it. When i click on some tabs the control scrolls, and i lose sight of the tabs. Meaning i need to scroll the control down again to see them. Can i lock the tabs in place to stop this happening?

Hi, Trying to be a simple as possible. I have a form (frm_Promo) that has 20+ fields on it, sourced from a table. There is also an listbox (Lst_promonames) on the form sourced from another table The user adds new record fills out the frm_Promo with all the details, and then selects one or...

Hi Hi have a graph (graph0) in a report in access, which has a nice image embedded in the plot area. I would like to change this image depending on the content of the report (name field). Is there a vba way to load picture into the plot area? Thanks :banghead:

Hello I have a subform and when you double click on any field it remembers 3 fields from the record you are in and stores them. I have 3 fields called [section], [losthrs], [stdhrs]. It works perfectly and stores the data from [losthrs] and [stdhrs] fields, but throws up "Argument not optional"...

Hi, I have a query which uses a table and 2 parameters from a form. The form is loaded/open and the 2 fields have data in them. However, when I run the query it ask for both parameters.... why would this be? Here is sql for my query and both fields "MCode" and "Current Rev" DEFINITELY have...

Hello, I have a small (8MB) database that we use to monitor vehicle panels. The user enters a panel ID and it calls an image from a folder. I have the paths stored in a table and use image1.picture = path However, every time the user is calling a panel to see it, the database is increasing...

Hello, I have a table tbl Packing List where the user inputs a product code. This field is restricted as it looks up possible values from tbl product list This works ok, as I have linked the tables. I would then like the description, also stored in tbl product list to also be retrieved into a...

Hi I have a crosstab query that reports KPI numbers for the last 5 weeks, using the week no as the column header. Then I am generating a report from this query. It works 100% However............ When I go to the next week, the report fails as the first week from the previous query no...

Hi This must be simple but i can not make it happen and am going insane. How can i put a fixed time for the current date in a text field. So the field will be 06:00:00 for the current day when the form is open? thanks

Hi I have table A with a list of Work Instruction references (WIREF) and a Issue number (ISSNO). I have Table B wth employees and they too have a Work Instruction (empWIREF) and Issue number (empISSNO). I want to check if the Work instruction Issue has changed since the employee was trained...

Hi I have a form with an image embedded in it. I want to be able to click on the image and leave a "dot" or "mark" where i have clicked, allowing me to click in multiple places on the image and leave multiple "dots" I am assuming i need to crate a new shape each time i click, how is this done...

Hi, I have txt input [txt choice] which has a number (1-9) and then a query which uses the following formula to define which records are visible linked to a Yes/No field =IIf([Forms]![frm selection]![txt choice]="4",Yes,Yes or No) If the choice is "4" then it works fine, but if the choice...

Hi, My Db has a linked table, to another Db that is password encrypted. When i try and use the following code mx_Check = DMax("MatrixNo", "Matrixresults", "rollno = " & [txt_po]) I get the error Run time Error '3031' Not a valid password Is there any way to pass the password through in the...

Hi, I have the following code to open and update a spreadsheet, that is linked to another source. No changes are being made, just simply opening, updating links and saving. Dim xl As Excel.Application Dim wb As Excel.Workbook Set xl = New Excel.Application xl.DisplayAlerts = False xl.Visible =...

Hi Have a simple query with input from a combo box. If the user selects 'All' i want to show all records. =IIf([Forms]![frm_Dry_tow_Chart]![combo_customer]="All","*",[Forms]![frm_Dry_tow_Chart]![combo_customer]) I have tried "*" (As in above example) and tried 'Like"*"', Is Not NUll, none of...

Hi, I am struggling to get the following code to work, all i want it to do is open a mailmerge document, and then merge. The Document is set-up and the merge works independently. Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(...

Hi, I have a table in my access db that is a linked table from Excel. To ensure this data is the latest, i want to open the source excel file, refresh it, and then save it. I have code to do this however, it will not let me update the source data as i am using it in the database.........as a...

I have a form with no scroll bars, no record selectors, no navigation buttons, and the cycle property set to current record. However when the users presses page down or scrolls with mouse, it moves to the next record in the data source. Can i stop this happening? The data in the form is...

Hi, I have a select query and it runs dpendant on the contents of 3 combo boxes, if all three are populated. However if only 2 are populated i want it to run the query and use ALL or whatever for the 3rd criteria. Select criteria is:- [Forms]![frm_pricefinder]![level1] Tried this:-...