Search results

Thanks, I already had code doing it like that, but ideally i wanted in a SQL statement, but embedding it does not seem to work, so will stick to the code solution.

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

No, that wont work Graph does not support pictures Graph0.Picture = "952QV HOOD OUTER.jpg" "Object doesn't support this property or method" It is just the plot area that needs an image not the chart object

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:

Thank you so much, that must be it. I am indebted to you. Have a good weekend.

Thanks, but i do not have a sub routine called "section" it is just a field name. So therefore has no parameters?

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

I have just re created the form from scratch with al the same fields and records identical and now it works! Must have just been a glitch... I will continue to check it, but there was no reason I could work out for the error.

The query runs from VBA but I tried opening it manually and both ask me for parameters, even with [forms]![frm_update] open and all fields filled...

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

Updated I tried removing a pictre that was added at design, which did not solve it. However, I embedded the image control and this seems to have solved it. I loaded up 50 images and no increase in database size so far. Thanks for all your help, much appreciated

No, I have a folder on the C drive with 100 images and the code is : Variable fname is called from a table of paths, but in reality this is what is happening fname = "C:\Automotive\Inspection\PROGRAM\Ferrari_F150A.jpg" Me.Image0.Picture = fname And I have the explorer open on a separate...

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

Hi Ok I have a user who wants to create a packing list, they will type in a code, and it will get them a description then they add a volume and it will calc boxes, and pallets etc, then this needs to be in a report. It could be 1 row or 30 rows I don't want 30 lines of text boxes and I can not...

Thought it might be, so I will get round it by using text fields instead of a table then output them to a table using vba. Thanks anyway.

Thanks, but it doesn't do what I need. I can use this method if I am filling in multiple text fields on a form, but not to populate 2 fields in a table it seems.

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

Thank you I had opted for solution 1, and it now works with a little bit of IIF magic. thank you