Recent content by slyvsspy

How do I go about deploying my MS Access Software that I build. Especially for people who don't own Microsoft Access. I have the Microsoft Developer Network CD's and I have MS Access Runtime. I just don't know what to do. Any suggestions. Thanks

THats IT! I searched the whole help menu trying to find the function to do that. Never thought it would be titled "LEN" Thanks,

How would I go about trying to find the number of letters of a word. In my database I have 900,000 words. I split each word into it's own letters using "MID(theword,2,1)". I have 24 fields. Letter1, Letter2, Letter3, and so on. What could I use to send the number of letters to a text box on my...

** txtTotal = Val([Field1]) + Val([Field2) + etc. You are a genious! Thanks so much this worked!!!

I have 24 fields on a form that I need added together. I am doing it through visual Basic. However instead of adding the numbers it literally adds them. Example. if the fields are, 2, 33, 6, 8, 5 The output is 233685 instead of 54. Can anyone help me out of this dilemma?

I want to use a command button to set a value of a text box to "Donors" when clicked. Does anyone know the code to do this. I thought it was this: Set Me.RepTitle = "Donors" but this didn't work. Thanks for any help!

How can I make the Switchboard form open up in the middle of the window each time the Database is opened and minimize the DB window.?? Thanks,

I run a macro that uses the "TransferText" function to export a query. I have to tell the function where to save the file exactly and with what name. How could I go about giving the user the ability to save the file with a different name? We are going to be exporting the query many times with...

If I have someone entering in a bunch of entries through a form, how could I not allow them to enter duplicate records based on the first name and the last. Thanks,

I am reading data out of a query with 3 fields: precinct walkingaddress walkingnumber I want to print data labels that show the Precint, WalkingAddress - which is actually the street name, and all the WalkingNumbers. I can do this using a regular report with group headers but is there a way to...

They are comma delimited. But with transfer text you can only do one file at a time and I don't want to do each one of a thousand files. I want to put all the files into one table on one import. Thanks for any ideas, Josh

I have 100 text files to import into a single database. How can I import them all instead of doing each single one? Thanks, Josh

Thanks but here's what I wrote and it only took a few minutes SELECT DISTINCT Voters.Precinct FROM Voters;

i have a database with a million records. out of the million records there's 50 different precincts. I don't want to scroll through the million records and write down each different precinct. Is there a way to run a query and pull off 1 of each of the fifty different precincts.

How would I set up a command button on a form to open the "filter by form" dialog box. Anyone have any ideas. I thought about using "SendKeys" but I don't really know how to use this function. Can anyone help me?