Search results

Hi folks, hope someone can help me with this one because it's got me puzzled (no change there then). I have a form with a subform. The main form has two cascading comboboxes on it which work fine. I have created 3 textboxes bound to a table and the corresponding fields. What I would like to...

Hi all, not had a lot to do with Excel since the early 90's so please bear with me. I have a spreadsheet with assorted data, one column of which could be used to hold file paths. Is there a way to open the file explorer window with the correct folders in it by selecting a particular cell in...

Hi, I'm having some problems with a form and getting data into some tables. I have a form, some of whose controls are bound, some are not, because I couldn't figure how to get a from to accept data entry so I opted for some vba and sql statements. Okay, so what I'm trying to do is write to 3...

Hi, could someone point me in the direction of some resource for the proper syntax of including, say, the output from a combobox into an sql string in vba? Many thanks, Lol

Hi, I have some sql below which works great in itself, but it is not for want of a better word filtering the data as I require. For example, say I have the following records below returned by the query: Drill 1| Yard | 25/3/18 Drill 2 | Van | 18/3/18 Drill 3 | Van | 17/3/18 Drill 4 | Yard |...

Hi, I'm having some trouble with updating the rowsource for a combobox which cascades from the one above. It DID work but since altering relationships in the tables along the lines of what Pat recommended the combobox now no longer works. There are 2 comboboxes on frm Product, cboCategory and...

Can't understand this one (no surprise) but I have a combobox on a subform. The combobox has two columns in it: Column1 and Column2. During use the combobox displays column2. when I review the record again in it's subform the field values are appropriate to column2. However, when I view the...

Okay, after many hours of trawling the net and head scratching I have to ask the question: is it possible to have a form with 2 cascading comboboxes which dictate which records are shown on the subform? in addition, I wish to make entries or modifications to the records displayed in the...

having some fun and games with two cascading comboboxes on my form. basically, after selecting a value in the 1st the second is updating but what I can only describe as th underlying value is not, and hence the subform which is displaying records (in theory) based upon the combobox values is...

Hi all, for those of you who experienced my previous horrors for equipment control I've gone back to the drawing board, cut out all the inessentials and got a much simpler design going. I have on the form a couple of cascading comboboxes which filter the products to display dependant upon...

Okay, so I'm trying to set the record source of a subform on load event of the main form. I have tried many permutations, some that supposedly work. main form is called frmBooking, subform is called frm_Location Here is what I have and I'm still getting errors: "The expression you entered refers...

Hi, I'm trying to create a tool logging database where tools are logged out from and to stores to different locations. I would be looking to enable new tools to be entered in the system, tools to be booked out and reports generated. I've attached the problem child for your consideration...

I'm trying to generate a recordset and use it to populate a subform. My SQL is good because I have run it in the Access query builder and it returns the expected result I just can't get anything to appear in the subform! I used a loop to fill the subform but nothing is showing. If anyone could...

Hi, hoping someone could help me with this one as I'm having a brain melt at the moment. Just what is the correct syntax for creating an ADO connection and a recordset therein? I know it involves declaring variables to hold strings and using the SET command but I would just like to know the...

Not quite sure where to put this one so I settled for "General". I've got a spreadsheet exporting data to an Access table. The spreadsheet is formatted to display 2 decimal places, i.e. 38.50 When it's copied via vba into an Access table though it is rounding down to 38.00 I've tried various...

As it says, I think the root of my problems are in the cursor settings but I'm struggling to nail it down. I have some code below and basically it's comparing two tables and finding the total number of records that have no match. It works so far but it keeps returning a total of -1 which I know...

Hi folks, not been doing much for a while and then the phone rings and it's work moaning about a problem :) Please see attached sheet as the site insists I am posting 58000 characters regardless of the browser I use!

Hi, could just do with some advice on network file paths. I have got an Excel s/s that exports data to a Access d/b via vba behind a button. In development the file path has been c:\ etc etc Now however the files are to be networked and the filepath I have been given is thus: office(\\brfile)...

Got a strange one here because I have used what i thought was exactly the same syntax in another query string and gotten no problems. I'm passing the value of a combobox to a string and executing it as a query in vba, but I keep getting asked for a parameter. I've checked the control name, done...

Hi, having got my sql in some sort of order in a previous post I am trying to insert the sorted fields into another table. Testing the code without the "Insert" clause it works fine, but when I come to try and insert the data into a table I get a warning from Access that it can't append all the...