Hello All, I have a Bound Object Frame on a form. In the field of the table I have a Word Document (not linked). Also on the form I have a print button. How do...
Dave, This does not have to be a complex solution, but more info or a db sample would be helpful. I'll give it a go if you're interested contact me at ...
Friends, I am looking for a function to use in a query that will Randomize an entire table...I looked in Help, but it did not Help. The records in the table...
What are you trying to do? Neil Squires ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]On Behalf Of j Sent: Thursday, September 01, 2005...
Neil, I have a list (table) of employees (750) that I want to randomize. The randomization could be by location, or employee number, etc. I hope that once I...
Personally I would probably use Excel to do it, but if you want to do it in access, I think you could write a code block that got used the rand() and/or...
I know that rnd([field]) is a function, but I did not know I could use randomize([field]). I'll try it....can't dance or do VBA! Thanks j ... From: Squires,...
Robin, As apparent, you wish to print the contents of bound OLE control, using the parent application of embedded document. In absence of file path, direct use...
I have had the same problem. While I don't know how to fix it, I do know a way around it. Instead of selecting "Merge it With Word," select "Analyze it with...
Thank you Frank for your response, it confirms my thoughts that there was a glitch in the Access wizard and not just in my mind. I have it in mind to create...
Hello A. D. Thanks very much for that code. I gotta admit I had forgotten all about verbs so without your help I probably would not have found it. Again, thank...
If memory serves correct, Rand() gets you a random number. Randomize() gives you a random key string. If you don't use randomize, you will get the same...
You are most welcome Robin! Best wishes, A.D.Tejpal ... From: Robin To: ms_access@yahoogroups.com Sent: Friday, September 02, 2005 18:54 Subject: [ms_access]...
Any access gurus out there? Using access to import a text file: When I get to the page in the import where one can click on the different fields to change the...
Dan, I do this all the time and never had a problem changing field names. Could you upload an abbreviated file (or send to me) and I'll try to import. Ed...
Dear Friends If I am using this Steps Dim db As Database, rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT Sum(t.b) AS Sumb FROM t WHERE...
Hi there, Really need some help. I have a table whihc among other things, contains email address. How can I send an email with an attachment to selected email...
Are you clicking on the "Advanced" button on the bottom left of the wizard? Guy Harley ... From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com]...
Where I can get all information/tips about using access 2003 with MSDE (SQL Desktop Edition) ? I look at many access 2003 table of content only view books have...
Hi, I've been sent an access program written in 2003, and I would loke to utilies the table and queries in a 2000 database. Is there a easy way to import these...
I have a chart in a report which is based on a cross tab query. The row Heading is "installation", the column heading is "Week" and the value is "Sum of...
I have a MS Access database on my hard disk. It is splitted into two mdb files, one for tables, one for queries, forms as usual... I have a newer version of...
Clauss Gilbert
gilbert.clauss@...
Sep 5, 2005 3:50 pm
18496
Gilbert With your database closed, rename the database on the hard disk and then copy the one on the floppy diskette and paste it in the same folder as the old...
hello i have a program in access that used many reports. after a time the pagefooter in mode preivew move to right after page one. what do i? Liveson Tumbulu...
I want to cycle through all the entries in a table to make use of some of the parameters. I'm sure its simple, but I cant do it. Appreciate any help The code I...
I had the same problem and had to re-install to correct it. One of the wizards were corrupted. HTH Mitch ... import where one can click on the different fields...
I am trying to bring in a table that contains a number column that often contains leading 0s. I need these zeros to be included in the number that I bring in,...