Recent content by nka

Hi Banana, There is no space in the code - not sure how it displayed on here with one. "FLTR_User" is the recordsource (query) Going to have a look at the error messages.....

Thanks Banana, I changed the code slightly as the form "SHW_UserIssues" has a subform (recordsource is a query "FLTR_User"). Now I am getting an error message when it steps through the code saying "You canceled the previous operation"... I haven't cancelled anything! Here is the amended code...

Hi all. I am not very good with VBA coding and manage to get around most of what I need using wizards and converted macros. However, I have come unstuck slightly with what I am trying to do. I have a form with an unbound field [searchuser]. I then use the following code to open the main form...

I've got another problem now.... I am trying to do a similar function - but I think I am looking at buttering my bread on both sides. This is the code I have: SELECT TBL_Employee.EmpID, TBL_Employee.FirstName, TBL_Employee.LastName FROM TBL_Employee UNION SELECT '0', "Select from dropdown to...

It's OK! I cracked it... EDIT - the textbox issue anyway! I only have to reference the combo box, it automatically selects the column for me! Now the next problem, for some reason it's not linking to my subform. I am getting an error message saying "cannot build a link between unbound...

Thank RG! I see the principle of this... but not sure I have the hang of it! I have created the text box as suggested and left it visible so I can see it working for the moment... Am I supposed to put some kind of requery/refresh on it when I change the value in the combo box? At the moment...

Hello everyone! I think I am asking the impossible, but can't think why it can't be done! Here's the dilema: I am working with an unbound form to search a Mobile Register. On the form I have an unbound combo box which looks up User details from a table (LKP_User). When I select a user, I...

Thanks for that! My memory was just starting to come back to me and you came through at the same time! That's exactly what I am looking for! Cheers :)

Hi All, I am trying to remember how on earth I did this a few years ago - I want to use a combo box to select the current month. Currently, the recordsource comes from a query, but I would also like to add a field at the end (or beginning) of the query recordset (?) I vaguely remember that I...

I guess it's hard coded... When the query is run/ran (grammar!) - a parameter box comes up asking for the stock number.

So while I have your attention.... If I had a situation where a value was entered in a query parameter to filter records and then export - how would I get that value into the filename? The query is a Make Query (makes temporary table), so the value is stored in the table... back to my original...

You beauty!!! Works an absolute dream! I knew it could be done - just didn't think it was so simple! Thanks for your help. :D

Getting there! That gives me the supplier_id (which is the bound column on the combo box and is hidden). Is there anyway I can expand on that to select column 2 (being Supplier_Name)?

Hi Ken, Yes (in a roundabout way). A form has the combo box CBO_Supplier which looks at Supplier_ID and Supplier_Name. Supplier_ID is the bound field, but Supplier_Name is displayed. However, both values are stored in the temporary table as there is a Make Table action once the Supplier has...

Hi all, I am looking to export a query (into Excel) and include a field value as part of the filename. Example of what I am trying to achieve: DoCmd.TransferSpreadsheet acExport, 8, "TEMP_SupplierItems", "C:/Data Downloads/EXP_SupplierItems_" & SuppName & ".xls", True, "" DoCmd.Close...