Search results

Forget that - i've sussed it. Anyone wanting to know the same then: Lo = "Hyp#" & Me.txtLocation.Value & "#" SQL = "INSERT INTO tlb_DocList ([Link]) VALUES ('" & Lo & "')" CurrentDb.Execute SQL

I have my user select a file from a file selection dialog. I then want to add a hyperlink into a table hyperlink field pointing to the file they chose. Probelm is, i don't want the displayed text of the link to be the full path (due to length issues). Obviously the 'Address' will be the full...

Ahhh... simple as that - thanks Galaciom!

Probably really simple... but: I have a main form with a command button on it. Also on the main form is a child form driven by a query, shown as a table. One of the fields shown from this query is 'ID'. How do I get the ID of the currently selected record (that the user has clicked on in the...

Brilliant! over a year after the above post and this just helped me out of a tricky issue :)

Do you mean a combo box? If so I've just dropped one on a form and can't recreate what you describe - mine stays as yes/no...

I have required fields on my form. If the user doesn't enter all values they get the unhelpful "The field xxx cannot contain a Null value because..." which is correct, but I'd like to give a more meaningful message. Can this be done?

I think I've sussed this but still need help, if anyone can. I think its to do with a space between the user entered fields. The GT variable could contain "Change Management", in this case the first SQL works but the third doesn't. Can anyone see why?? SQL = "INSERT INTO...

Thanks for the reply, but no better unsing that cache refresh thingy. Also, the sleep(500) aint working either now making me believe this is more involved than first thought.

I run three insert queries to populate the tables in my db - code below. If I run through line by line using F8 then no problem, but if I let the code go at full speed sometimes (most of the time) the final statement fails. I reckon this is because of the relationships and trying to execute the...

Ahhh... I understand your thinking. Thanks for the reply. So I make a dataset of the two tables to get all the part numbers then add queries based on that.

The answer to this must be simple, but highlights my lack of knowledge of union queries - help guys! I have a table with two price lists in it, say 2007 and 2008 price lists. I have two queries (for simpicity) that pull the data into seperate entities, one for each price list. I want to compare...

Forget it - I'm being a div!! I had typecast the variable to expect a string - sorry.

I am pulling values from a table in a loop and there are occasions when th ereturned value is null, which errors because, I believe, I cannot assing null to a variable. Is there a better way to code this or do I really have to check each one with 'If Isnull(...'

Me too. It was the reassigning the sourceobject that was causing my subform crosstab to screw up. Thanks for the help :)

Excellent. I understand what you are saying, and by reading the link you posted, and am now working to redesign my code. Thanks very much for posting your help.

No, it has 3, but the other two are taken from data directly on the form (i.e. not in the code loop iteration)

Error: Type mismatch!

Well, to put it another way, if you wanted to append data to a table from week x to week y (user parameters) how would you code it?

Can someoone tell me what I'm missing here? Its gonna be something daft I know... The append query just adds data to a table incrementing by weeknumber. The error I get is '3061: Too few parameters...' as it tries to run the line 'qd.Execute'. Dim SWk%, EWk%, i% Dim qd As DAO.QueryDef...