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

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

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

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

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

hello, i am using ms access 2k. I sent an e-mail using DoCmd.SendObject acSendReport, "Contract", acFormatRTF, TTo, CC, "", Subject, Msg, False through outlook express. WORKED GREAT!!...problemm is we use groupwise. i have seen api's to download to use groupwise...

Hello all...ive read other threads of people trying to do this, but they all seem psuedo code...nothing i can really grasp dealing with this. I want to send a report attached to an e-mail, but i only want the person to see a specific report...based upon their ID number. I have the report made...

When printing a Report, I have a listbox that i would like to have no lines around. I have changed the property settings, but when printing the lines still show. Is there anyway to get rid of these?.... eric

Ok...sorry this might be long...but ive tried everything difficult...and theres probably a simple solution. I have two tables. The First (Employee) contains First Name, Last Name, Salary, Degree Type, and Years Experience. The second table (SalaryInfo) contains Years Experience, Salary...

i have a listbox updating a table...im curious as to when i should be able to see this change in the table itself. I have a textbox that is controlled by the table. I change the listbox and the text boxes changes through the table...or so i thought. When i immeditaly view the table...the...

i have a list box whose ROWsource is from a query. I have the SAME list box whose CONTROLsourse is a field in a table. If I run the query which puts a value in the listbox, the listbox doesnt update the table field. I have the listbox requery even. BUT if i click on the list box, it will...

Hello all :)... i have a list box whose rowsource is a query. I would like this list box to then control a field. On update i would like first for the listbox to requery then the controlsource (i.e. the field it controls). Is this possible?.... if not, how do i get the field to be...