Search results

Hi Waypay, Been away on business so I haven't had chance to reply. I couldn't get the SQL command to work at all using: "fitters.fitter_id = [Forms]![edit_job_awi]![tbfitter_id]" However, to get it to work I declared a string variable and used: "fitters.fitter_id = " & fitter_id_var &" And...

Basically I have: The main form (bound to the AWI table) which has the combo box (called cbfitter) which shows the workers names (from the table called fitters). When this combo box changes a text box (called tbfitter_id) shows the worker ID number. This is done by having the text box control...

Waypay - thanks again for the help! :) To get this to work I am going to need the WorkerID in both tables, you did say so ;) So, what I have done is to add a textbox to the form that brings in the workerID (the control source for this is set to column 1 from the combobox that brings in the...

Hi Waypay, Yet again your help is outstanding! This is exactly what I would like to do however, not this complex. What I would like to do is not write the records for the worker or the job date but simply query and show (in the pop up box) the jobs that this worker has for the 2 week period...

Hi Waypay, Ideally, showing all jobs a week before and a week after the date from the calendar picker field. But any help on this would be most appreciated. Thanks again your a star! Cheers Jay

Waypay, Ideally, I would like a popup box simply showing the date, worker and and a job number associated with that worker in the combo box. Any thoughts? Cheers again, Jay

No seriously thanks again. One more thing though when I have selected a worker from the drop down box I would like to click on a button that would show a list of that workers assigned job dates. Could you give me a steer on how that could be achieved? Cheers Jay

Hi Waypay, When I add the vbSaturday into the code I then get a pop saying "Enter Parameter Value". The dialog box show the wording "Sat" then a text is below that needing an entry. Any ideas as to why? Thanks again for your help. Jay UPDATE - Waypay, I added the SELECT CASE option to the...

Waypay, You are a star thats perfect! I have added this into my database and it's great. However, when I pick a day, for example a Thursday, from the calendar picker it retrieves the records where Friday is YES. So, in a nutshell it returns the records from the next day from the date you pick...

Hi Rabbie, Thanks for the reply! I see where you are going but is it possible you could help me out a bit further. I apologise for my lack of understanding but this specific task has me really stumped? Kind regards, Jay

Hi all, I hope someone can give me a few pointers on this question. I have a table of people (called "workers") that can only work on certain days e.g. Joe can only work Monday and Thursday. These are set by having seven Yes/No fields called Monday to Sunday. I have another table (called...

Excellent! Thanks Fi that works a treat! :) Cheers

Thats great Bob thankyou very much I got the cascading working from checking out that example. :) One question I have though is how do I manage to save the contents of the combo boxes from Table B (which is simply data to bring into the form) to Table A which will hold all the info for an...

Hi everyone, It's been a long while since I posted on here and it's great to be back! :) It's also been a while since I used Access so I feel a complete newbie all over again! I hope you can help ... I have 2 tables. Table A contains Job information such as the date, order number etc. Table...

Tried that, however, it won't let me do it????? I thought I could achieve this via code - am I incorrect? Cheers

Sorry to bump this up a bit - but I am struggling to achieve this can anyone point me in the right direction? TIA

I would like to run VBA functions from other databases via a menu, a bit like a switchboard. For example, I have one module in database A that outputs a few spreadshseets - I would like a button on a form in Database B to run this.I have limited coding experience between databases so Could...

Why not have the spreadsheet name stick to the same kind of format but then append something like the date at the end. eg "Information 12/01/2005.xls" Then you can run an import via VBA with the current date appended to the end of it. Sorry, "12-01-2005", Excel doesnt like the forward slash!

Pat, Thanks for you reply. I guess my wording was a bit vague! Here is the function: -------------------------------------------------------------- Public Function process_location_spreadsheets() Dim locationnum As String Dim output_file As String Dim extension As String locationnum = 1...

Hi, I am exporting data from a table to Excel files (in a loop) - called location101.xls, location102.xls etc from a docmd.outputto in a function. In this function I have a counter that increments in each loop that updates the file name. What I would like to do is pass this counter number...