Hi Stan, I ran into that problem some time ago and it took me over a month to figure it out. The following code works seemlessly me for me on my PC, but on my...
I tried putting an error trap on it myself, but couldn't get it to work and access would blow up on each attempt. I searched the archives too and wasn't able...
Liz, As stated in your post, you have resorted to splitting the contents of memo field into multiple substrings, followed by eventual concatenation. The...
I added the sql statements and that's what's not working, I thought I could declare these statements, add the sql and it would work. I have stepped through...
Thanks Bill. I'm starting to go a little crazy with all of these database problems. I'm a data analyst, not a programmer, or developer, or anything like...
I am creating a Form in Access. I need to bring a picture backgroud to lay fields on it. I can't get the picture the correct size in Access. Any help is...
I'm creating a database for our clinical staff. They need the client's diagnosis, in each note. To create a new note, they select the client's name from a...
aj, The problem reported by you arises when trying to create a recordset based upon query using parameters. A convenient remedy lies in replacing the...
Darrell, Thanks. I'd figured that part out, just not WHAT parameter. This VBA is too far advanced for me - I'm going back to my tried and true macros - they...
What you need to do is set the form's picture to the image you want. That way it will stay the size of the form. But keep in mind this will add a lot of bloat...
I assume you mean the Left() function. The Left function gets a number of characters from a string starting with the first one and moving to the right. What...
AJ I hate seeing you say that. While I have nothing against macros (no, really!), I don't like seeing someone who has come so far in Access developing just...
Pierre It would be nice if Microsoft made developer's editions/extensions free going back to all versions, but I doubt it. But think about it, this is a really...
Carolyn Yeah, it's really pretty simple. About booleans (bits). Access sees them as -1 even though it understands how SQLS stores them as 1. But, your Access...
Ed You sound like Bones on Star Trek. "Dammit, Jim! I'm a doctor not an engineer!" Every successful job grows as the employee grows. I wasn't always rich and ...
Okay, Bill, I hear you. It's just that I was in a time crunch. This group (WQ and EPA) had their meeting back at the beginning of January, IT offered the ...
I have two tables that are linked together. The first called tblPO has a text field called VendorID it is the fk to tblVendors field VendorName (text). WhyI...
A.D., Thank you so much for both the explanation and the examples. I have been trying them out, and have gotten the program almost to work. Actually, I can...
Jim The error break setting that Clive gave you should be used for debugging only. Distributed databases should have the setting on "all unhandled errors" The...
aj, It is nice to note that you are making good progress. Please go to VBA window, open the Options dialog box (click Tools > Options) and go to General tab....
A.D. Please disregard the following question. I managed to talk to our server people, and found that, although the path to the spreadsheet is listed as that...
David, Could you please refer to my post of 30-Jan-2007 and confirm whether sample file Query_MonitorAnnualEvents.zip has since been downloaded by you? This...
Charles This is certainly not going to be easy changing keys in existing records. But it can be done if you use care. Set up: 1. If you have a relationship...
A.D., I checked all the reasons Bill mentioned that could cause the Access bug to respond the way to memo fields. I didn't have anything going on that matched...
I have solved the problem. How I did it was to delete the relationship and then I wrote a vb.net program to bring in the VendorName and VendorID from the...
I have a form with a text box and button and want to run an Access query that takes an input parameter. I have the following code for the button: I get an...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
