Search results

Thanks for the pointer, I'll try that and come back if it works or not :)

I seem to be having the same problem, I have read the article on connecting to a secured database (http://support.microsoft.com/default.aspx?scid=kb;en-us;208933) and followed the instructions, but still get the following error message when I try to connect. "Test connection failed because of...

Definately make a field for each question, you will be able to choose different field types such as text, dates and checkboxes etc. So for the field "Did you like the book" you only have to click the tickbox rather than typing yes. Also memo fields can hold large volumes of text in case you have...

Okay, I've heard that this isn't possible, and searching the forums for AutoText didn't yield any results for me, so I thought I would ask here. Is there any way to link the AutoText in word to the entries in the database? I am thinking along the lines of exporting database entries to a...

Thanks for that :)

I am sure this is very simple, but I'm not sure what it is that I'm looking for. As always I've spent time searching, but I don't really know what I'm searching for at the moment. What it is I'm looking to do is to have a list of all the clients in the database, and then have the total number...

Erm, I think I will illustrate the problem with pictures when I get home and have a bit more spare time and photoshop, I'm finding it really difficult to explain my problem properly. Thanks :)

Well, TimeEntry has a query on it, and the form to view this query through is TimeQuery. What I want to do is run the same query again from TimeQuery, an example... I enter Staff ID - BF and Date - 01/01/06 in the TimeEntry form. The results open up in TimeQuery. Now I want to find Staff ID -...

I thought as the fields may or may not be null it should work, looks like I was barking up the wrong tree :rolleyes: Sorry about that, could you give me some pointers as to how to achieve this effect another way? :)

Hi, I am trying to use the NZ function but I just can't seem to get it to work when it looks up two different fields, here is what I have at the moment... Criteria for Date: Like NZ("[Forms]![TimeEntry]![DateTop]","[Forms]![TimeQuery]![DateTop]") As well as... Criteria for Staff ID: Like...

Thanks for the great code, for the moment I have implemented the control buttons with "Select All" and "Deselect All" on for the moment, but if the users want to change it to a toggle or checkbox that code will be invaluable. Thanks everybody. I feel like I'm getting good at this ;)

This is what I used to get a similar result. I'm just worried about if I had one entry of "Bryan Smith" and had another entry of "Bryan Smithson" then I think it would return both, right? Personally I think that it wouldn't affect my database as the field I am searching on should contain very...

Ahah, I was hoping to modify it further so that it would be a single tickbox rather than two buttons, but I guess two update queries would work as well. Thanks :)

Hi, I've tried a similar bit of code on mine, but I can only change the value that I have selected, so the button changes the current checkbox, but doesn't change all the checkboxes on that page. Is there a way to make it change all of the items on the form? Picture added in case I am not...

I used a "Step By Step Ms Office Access 2003 (Microsoft Press)" PDF and also have an "Access VBA Programming" CHM. Most of what I wanted to do was pretty straight forward in the end. I would be happy to share the files, but I'm unsure of the copyrights associated with them :)

Just to say, I've looked around the forum, and combined with an eBook I found you guys have answered all my queries. I just wanted to say thanks, because I'd have really struggled otherwise :) Thanks! :)