Search results for query: *

Hi--I'm an Access guru, but someone at work is trying to do something MS Word and I'm trying to help him. I'm not up on "forms" in MS Word either. He made some check boxes (I see now he did it with the ActiveX controls instead of the "form" toolbar) - he put them in the footer of the first page...

Access 2003/Win XP: I've designed forms with some flat controls. But on other people's machines I see that they are sunken. Any idea why, or what I should do to make them flat on everyone's machines? Thanks. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or...

Access 2003, multiple users, FE on machines/BE on server I've re-written a db to make it faster for the users, so that only the data for the Widgets they are responsible for is written to temp/local tables in the FE on their machine, then when they are done the data is written back to the...

Hi--I used to write big macros in Excel years ago, but since using MS Access, haven't been in Excel too much for about 8 years. I need some help figuring out how to correct a problem in Excel that is affecting my MS Access application. At my company, there's a web-based application which...

Hi. I launch vbs files from Windows Scheduler to open/run MS Access db's (2003) at various times during the night. In the VBS files, I set the security of the db to low so they'll open and run. One problem I now have is that db's with MS Access security--I need to know the syntax to make them...

I have a db in Access 2002, Windows 2000. Works fine, but sometimes various users calls and get an error on startup. I just went to such a user's machine, and in trying to run a query which calls Environ("Username") (i put 'environ' in vba code so that's not the issue) which runs on startup, i...

I'm exporting a report from MS Access to MS Word (rtf, which is the only feasible choice). The users will have to edit that Word doc frequently. However it seems when it converts from Access to rtf, there's a paragraph mark at the end of every row of text, like this: here's a pargraph of text...

I'm exporting a report to MS Word (rtf). The users will have to edit that frequently. However it seems when it converts to rtf, there's a paragraph mark at the end of every row of text, like this: here's a pargraph of text that% is one single paragraph so% it won't wrap around% when the user...

Hey there. I've been using Environ("Username") successfully for years. Just deployed a new db recently, and one person gets an error. After investigating on his machine, the error is it doesn't recognize "Environ". I checked the references and none are missing (I have DAO 3.6 and Active X Data...

Hi. I still need help on this: thread68-951088 Thanks--g

I'm an Access VBA girl, and having trouble with some Word VBA. I never do any programming in MS Word, so I'm struggling. In my Access db, the user hits a button which exports an Access Report to MS Word. It has to be in Word per gov't regulations, in Courier 12, and other certain formatting...

I am trying to replace a current process which involves a whole person compiling mulitple MS Word documents written by multiple people in multiple formats. I will have the users enter their info directly into a db. At times they will alter their inputs, in which case the edits must be captured...

Hi. I need to know how to get the value from a query when a user has clicked in a record. I have a set-up where when a user clicks a button on a form, there is a query displayed, with 5 subdatasheets. They navigate down thru the subdatasheets. I would like when the user clicks a value in the...

i have an area chart, based on a crosstab query. i have manipulated it so that one field will always appear as a column heading on the far right (i made it alphabetically the last). i want this area chunk to always have a certain format (blue and white diagnol stripes), but it will always be in...

i have an area chart, based on a crosstab query. i have manipulated it so that one field will always appear as a column heading on the far right (i made it alphabetically the last). i want this area chunk to always have a certain format (blue and white diagnol stripes), but it will always be in...

Acc2k. been searching but cannot find what i need. i have multiple reports that when a user clicks a button (actually on a toolbar) right now, i force them all to print to our office printer. however i would like the user to be able to select which printer they want only ONCE, then print all...

acc2k--keeping a log of changed, added and deleted data. all fine, except i can't figure out the deleted data: i have a main form. in the subform, is just a list of related 'areas'. a user can choose one and hit DELETE key. once they confirm delete, i want to log into my EDITS table the value...

hi guys--i'm an Access programmer, but some of the guys i support wanted me to put a bunch of their excel stuff into Access for them. I need to re-format their spreadsheets to go into Access properly. it's been 5+ years since i've worked in Excel and can't quickly remember how to do what i want...

Access 2k: i have a subform (datasheet) where i want all but one field greyed out all the time so users see easily those fields are non-editable. one field always has a value in it, at least a 0 so the condit formatting is >=0 make it grey, so that works fine. two other fields tho are NULL (i've...

moving an Acc97 db into Acc2000. lots of charts. i have two machines, have been running some tests. for one example, it takes Acc2000 47 seconds longer to process the chart (counted with my extremely scientific One-Mississippi method). this is typical. upon hitting The Button, lots of queries...