Recent content by lilakathy

my db was 52 mgs before i deleted 12,000 records and 52 mgs after i deleted them where does the deleted data go? how do i get rid of it and have a small db again? i clicked on "properties" in "my computer" (i am on windows 98) before i started deleting to see how big it was (52 mg) and i did...

i copied my database, renamed it and then deleted all the data in the tables. How do i just copy the whole database itself, with all the queries, the design of the forms and all that stuff, just not the data without deleting the data in each table? i have spent hours reading and trying to...

Hi, i am new and am tweaking my new form. i have a field called "drafters". we use only their initials as the value. but there are so many of them and they change often. i would like to click on a lookup list and see their whole name and their initials. then we would know which initials to...

this is a whole new area i haven't read about. this will be my next step. thank you for your response..

i've got it. your word "control" helped. it worked when i right-clicked on the control in design view of the form and chose properties then format and then typed ">". thank you. I don't know why it wouldn't work in the table.

I have access 97. i want to make all text uppercase no matter what i type. I am in the General Tab in the Field Properties section of my table. I tried two things: 1. putting > in the format section 2. putting > i the input mask section i saved each time and closed out access but i can't...

this is the SQL View of the query i am trying to export before i tried the new recommended statement. (the two date fields are ABD Recv'd and Returned to Atty2.) SELECT ABD.[DocNo:], ABD.[ABD Recv'd:], ABD.[Rush3:], ABD.[Drafter2:], ABD.[Returned to Atty2:], ABD.[Comments3:], ABD.[New2:]...

sorry..if i keep replying to the same response..i thought that was a thread. i did post the similar question under "tables" a few days ago but i saw the error in that and quit. but i am not confused, actually i just read the statement wrong, but i did not copy it wrong. i still have the same...

RV, i am feeling really stupid. i was studying your statement and now i notice that you put in the "Expression 1" and "Expression 2". i stated in my last reply that access changed it all by itself.

i copied and pasted exactly. when i exported the query, the export text wizard window said: too few parameters. expected 1. so i tried to open the query and a window popped up that wants a parameter. i made up a date for the fun of it and that is the date that printed in the datasheet view...

oh boy....we are getting sooo close (notice is said "we" :-) i copied and pasted your exact statement. an error box pops up and says this: undefined function 'abd.format' in expression when I click on it further, a window opens up and it reads: Undefined function <name> in expression. (Error...

hi. I reread the date formatting again in help. i tried different combinations of codes in the sql view and in the "properties box" of my two date columns. i am still getting it wrong. This is exactly how my sql view looks in my query: SELECT ABD.[DocNo:], ABD.[1st Rev Recv'd]...

i received this excellent advice: Use the Format function in your query to export in the format you wish to: Format(YourDateField,"dd/mm/yy") but i cannot figure out HOW or WHERE i enter this information. when exporting date/time field i get 00:00:00 along with the date. i do not want it but i...