Search results for query: *

Hi all, I've created a nice access 2002 database, but am now looking at the front end. The GUI that access provides is nice, but not smooth looking. I was wondering as to what options i have when creating my front end to the database. Does access 2003 have some smoother looking GUI options...

well here might be a possibility, but there might be a better way First set echo false DoCmd.Echo False Then open forms while loading database Also set the on open properties for the database and change the forms visibility to false Dont forget to set echo to true. this seems like a total...

well i didn't solve the problem, but i did find a solution. Instead of requerying the form i just decided to requery the Recordset. I guess I was overdoing it with a form requery. eric

Bill, Im no expert, but i think if you have a recordset that produced 0 results and try to move to the first record you might get both EOF and BOF. I would try to put an if statement If rs.EOF and rs.BOF Then MsgBox "No Records" Else rs.MoveFirst End If or somethings of that...

Hi all, I've posted this quetion in a different thread but have a much better grasp on it, so decided to start a new thread. I am trying to Requery a Form which brings the record set to the first record. I need it to stay on that record after updating the form so i've used the bookmark (and...

hi all... thanks for the posts, very helpful information...i did not know bookmarks exsisted (they cut my code down quite a bit), but im having a small problem...When i run this code under an Afterupdate on a combo box i get a 3021 run-time error VarBKM = Me.RecordsetClone.Bookmark...

I have a field that is condsiderd a "memo" type of string. This means im allowed to put in more than 255 characters into the field...or so i thought. I now want to display this field in the report but have no means of doing this. If i use a list box i can only fit so much on the...

i am trying to automate pdf printing. To do this i am using code that changes the printer to the Adobe PDF printer using the printer object in access 2002. If i use windowsXP with Adobe Acrobat 6.0 Professional software this works fine. BUT when i use windows 98se with Adobe Acrobat 6.0...

hi all... I have a code that changes the printer to a pdf writer...creates the pdf file...then e-mails this file to a person. problem is that it prints the file to pdf writer but tries to send the file before the file is actually created. i dont want to just put a generic pause in place in...

thank you!!!!!

i want to populate a table with info from a txt file...but first i want to make sure this table is blank...nothing there...i must do this before populating...i tried this... Do Until rsPeopleNotEmailed.BOF rsPeopleNotEmailed.MoveLast rsPeopleNotEmailed.Delete Loop but it give...

i am trying to open a report that is limited by the SSN field of the table PeopleNotEmailed. When typing in the following i get a pop up box that asks me for [PeopleNotEmailed].[SSN]. I know i spelled it right and that there are numbers in there. If i instead plug in a number for...

hmm...yea sorry guys... ReDim Preserve NotEmailed(1, NotEmailed2 + 1) was suppose to be ReDim Preserve NotEmailed(1, NumberNotEmailed2 + 1) thanks for all the help eric

thanks!...ive gotten further...this is what i have ReDim Preserve NotEmailed(1, NotEmailed2 + 1) NumberNotEmailed1 = 0 NotEmailed(NumberNotEmailed1, NumberNotEmailed2) = rsPayroll!Name...

I have declared an array called NotEmailed() I redim it later in the code as showen....it resizes this fine the FIRST time....any other time it comes across this code it says subscript out of rang....why will it work the first time but not the second...ive checked the numbers the second time...

ive noticed that visual basic has a printer object and that it is more easily manipulatable...why doesnt access have this?...how do i import this object into acces?... eric

hmm...ok, been trying, this will take a while... one last question before i dig into this hard...do you have any idea if the pdf file will be larger than the snp file?..or how i can find out?..thanks eric

scriverb....once again you have the answer... actually, i think im going to pdf file now..hopefully that will work a little smoother..didnt reallly like thye snp file. anyway, i saw code to put in access as a module and then it seems easy to output as a pdf... i asked this question else...

i like that...it seems like it works nice...but, one question...what would be wrong with setting the default printer to a pdf writer...then printing the report? it seems that does the same thing...right?...

once again...you did it...thanks!! i guess as long as youre on a roll...got another one for ya...way off the subject.. i am outputting a report to rtf format. the only problem is only the text shows up. In the report i have shaded areas that need to be there. i have also tried html...