I burned (in multiple sessions) a 650MB, 74 Min CD-RW CD which was and is readable on other Win 98/ME/2000 PCs. I add new folders and files to it from time to time.
My burner is an external "HP cd-writer 8200." The CD in question is a Sony 1X2X4 rewritable CD.
I've tried to read...
My Problem: I need to export graphs generated charts in MS Access to MS Word, but can't find anything about how to do it. Of course "cut & paste" to MS Paint works, but is not satisfactory for my application.
My questions to the forum are:
1. Is anyone familir with how to do it?
2. Is...
Even with grouping, if your group fills up a page and runs over, you still have no header on successor pages. Can you build your field header into the page header? I commonly do this, even with multiple line headers.
A make table query deletes the old table before the (new) table is created. Worry about formating at display or use time, not when the data is stored. When displayed or used it can be formatted if and as necessary.
I've seen a post that say use [FieldName]+1 to get to the next record, if this is true, I suppose that [FieldName]-1 would get you the previous record.
Personally, I would use a recordset of the table, loop through it with DAO code, always keeping the previous value of a particular field...
Your mdb should be stored on a Server(file or folder) that Users are only generally aware of and only have read access (no pun intended) to.
That mdb is then copied to each Users harddrive from which it's ececuted, alternatively, each user has a batch file with does the copying at StartUp and...
Once you set the margins for a report in Access, they are set, regardless of the margins in other reports.
If you think that you need to set the margin every time you open a report, use Sendkeys (see the Help menu)
Build a query with the correct field, then use that query as the recordsource for your combo box. Youn can have any number of fields displayed in the combo box drop list.
Trap your strSQL when it's finally built utilizing a breakpoint and put in the QBE SQL frame to see if it will execute.
Alternatively, build your query in the QBE frame, test until it executes properly, and then look at the SQL gerenated for that query. compare it to your original code and make...
First put a field in your query to select the first 2 characters of the field:
Expr1:left(Article,2) with a criteria of "tx"
then add another field in
Expr2: right(Article,len(Article)-2) - this allows for the right most portion of Article to be other that a fixed length.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.