Search results for query: *

I don't know if this is a network security/permissions problem or an Access problem, but heregoes: A client had 4 machines, 3 running Win2K & A2K and 1 running WinXP & A2002. The split db worked just fine under that scenario, no version conflicts. Client upgraded the 3 machines to WinXP and...

One tab on my tab control has three subforms on it. They work fine - no flicker. If I add calculated textboxes that perform calculations on the totals of the subforms (the textboxes are below the subforms on the tab control), I get one flicker per text box. ie: if I have four calculated...

The below code works great, but it relies on a string (in red)holding the absolute path to the icon file. I want to pass a public variable (I've already defined it, and it works elsewhere) that returns the relative application path. This is where the icon file will be. If I have my global...

Do relationships defined before splitting a database show up in a back-end relationship window? Mine don't. Hitting "show all" doesn't help. Only relationships that I defined in the back-end post-split show up. Thing is, everything acts normal! Jay

Problem: I have table with an autonumber field. I delete the table's records via a Delete Query and then run several append queries. Problem is that the autonumber field does not reset (you'd have to compact after deleting records to do that - not practical). The autonumber field values would...

Is it possible to create a shortcut with a UNC path to a resident hard drive (like c:)? I've tried every combination of \\mycomputername\folderonCdrive\fileonCdrive and \\mycomputername\nameofCdrive\folderonCdrive\fileonCdrive and the like. Do UNC's not work on non-shared resources? Do UNC's...

I have a popup form that comes up in front of the main form. The main form has a public subroutine that "refreshes" the data on the main form. I want to execute the "refresh" sub just after the popup closes. How do I execute a subroutine behind one form from code behind...

I've searched high and low for this one, to no avail... I need to automate saving documents created by a mail merge. I've found code for that, however, the filename needs to be based on a bookmark (basically one of the fields from the merge). Since bookmarks don't survive a "merge to new...

I have a form that I could make copies of and change each copy's recordsource to one of my different queries. Alternatively, I could code changes in recordsource for just ONE form. The latter seems better for long-term maintenance. I'll only have to make changes to (1) form, rather than many...

I've been struggling with how to improve form opening & closing without screen flicker. For the most part, "repaint" & "echo" solutions don't help. A solution that helps is 1) eliminating menubars; 2)making all forms over-sized popups with no scrollbars; 3) always keeping...

I have a nice gradient .bmp I'm using as a background (embedded picture / stretch). It causes the form to flicker when scrolling through records. I've tried "echo" & "repaint" advice found here, but to no avail. Anyone figure this out yet? Jay

I have a couple of forms that for some reason are now returning blank "detail" sections if no records are returned from the source (a query). I don't mean the records are blank, I mean the entire detail section is not there! No fields, labels, or anything. Any ideas? Thanks. Jay

Ok. I screwed up and had a few Shockwave/Flash movies on my forms for a jazzy look. Once I discovered the reference hell I would have with client computers, I removed all Shockwave/Flash fluff from all forms. I now have a client computer (using an identical FE .mdb as other working client...

Word document with mail merge from Access data source. There is an auto-updating date field on the document. When I merge, it comes up as {TIME\@"MMMM d,yyyy"}. Why is it displaying the field code instead of the date? All the merge fields display correctly. Sure, I can hit...

The following code is called from a button on a pop-up form. There may be any one of several identical forms (whose only difference is data source) behind it when the popup closes (via DoneButton). Obviously I need to avoid referring to the underlying form name explicitly. This code does not...

I have the following code in a module: Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office\WINWORD.EXE C:\MyDir\MyWordDoc.doc /MMerge" Call Shell(stAppName, 1) If the user has Office XP, the path to the Office executables is changed, for example: C:\Program...

Anything wrong with remote-administering security settings by distributing updated .mdw's? If my client adds a new employee, I'll need to add their security settings to the .mdw. I don't want this long-distance client to do it themselves (don't want them to belong to ADMINS). Anyone see a...

Is there any way to compact a secured .mdb via a desktop shortcut using /compact without the user having to log in?

In a macro, a make-table-query runs, the resultant table is then transferred to another database. That database is used as the source for a Word mail-merge (all automated w/i the macro). If the query returned no records, Word of course gives an error saying the source was blank. I need to...

I'd like to know if anyone has used this tool put out by Database Creations, Inc. How do you like it? What are the drawbacks? It looks like a dream come true, except that it can't be used on secured mdb's.