Recent content by ejmiller2

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...