Recent content by j.smith1981

Hi there. I was wondering if there's anyway of allowing a macro to copy over data contents for a csv file (the whole file contents, which accumulates to about 7,000 rows), without copying and pasting, also if its possible is there anyway of making it do this without even opening the csv...

I think I have worked this one out. Without making this way too overblown and complex to script/program in VBA or whatever. I have decided to make a manufacturer_type table, with the following example: manufacturer_types: id | type 1 Cartridge 2 Printer This then links to the...

Ok I have a real problem here. I have a parent combo box named 'cmb_cartridge_manufacturer' yea? (as its reffered to on the access 2007 form) I also have a child one thats called 'cmb_cartridge_select', when the user selects a manufacturer it limits the number of cartridges in the child combo...

Not to worry I've sorted it. Sorry I didnt get back to you before you replied but yes it worked. I do apologise about that though. Kind regards, Jeremy.

I am starting to loose the plot with this extended SQL query I am trying to perfect in Access again, sorry this is as much of a repost of the same SQL query I asked you guys for. But could you help me come up with a more suitable way of allowing the user to enter empty cells and query the...

Hi there, I have had soo much help from you members in the past, your help has been invaluable to me getting my employed work done, I really appreciate it! This is why I have turned to you again. But haha, I have another problem that I think some of you might be able to help me with. Is...

Hi there, I have a bit of a problem here. I got working on a most workable solution for a form, now I will explain the situation before I explain the problem. I have a ink cartridge codes table, with an id field in there which relates to a manufacturers table. As I worked out there would be...

Actually I banged the filed boolean tickbox in the same bit aswell and its working better now. Thanks again, Jeremy.

That worked, thought I was going mad!! Thanks ever so much!

Hi there, Thanks ever so much for helping me out requery a form based on the adding of new entries and going back to my main form, its been a real help!! I am having one slight problem though. I have a tickbox, that when you check the tickbox, a file_location textbox appears, for the user to...

I am not sure if I have worded the title for this thread correctly. Here's my dilemma, I am pretty sure there's a away around this though, but any advice is greatly appreciated. I have a form, a series of drop downs to select printer cartridges yea? I want the user to be able to add print...

Sorry to trouble you again, just a bit stuck. I am trying to validate this form against the idiot user if you like. But is there anyway of making it so that, if the user inputs say 01/01/2009 in the from date field, and then enters a lower value in the to date field, like something daft like...

Thats wonderful it worked! I think its just a Monday, thats my excuse, looking at SQL on a Mondays not good for me, but thank you soo much for your help. Really appreciate it!

I am getting really confused as to why this isnt working. I have it working so when the user cant enter a date range but is it possible to get this working: SELECT data.test_date, tech.id, tech.tech_name FROM tech INNER JOIN data ON tech.id = data.tech_id WHERE (((data.test_date) Between...

The guidelines in the link you posted above worked, thanks ever so much!