Search results

You want to look into using the InStr function to find the text within the string, and most likely the Mid function to return the substring you are searching for.

"Local" drives do not change, nor do you need UNCs, only Network Drives.

make sure you dynamically build the dbPath statement, i.e. your My Documents folder is not the same location as the next user's My Documents folder. Also watch for differences in mapped drives, I'd reccomend using the UNC address for network assets instead of drive letters.

place the particular DoCmd.Open code in the On_Change event of the combo box... use the current selection of the combo box to determine what exactly you need to open

look at the Shell() command

tgtNum = Left(regNum, 1, InStr(regNum,"/"))

first click = start point. second click = end point. instead of clicking the second point, click and drag to produce the desired curve

Ahhh...my first car...1986 Pontiac Fiero 2M6, 4spd, mid-mount, all black. Loved that car:D Couldn't find any on-line pictures of it's final disposition. Did a Chevy V8 conversion and applied the Testarossa side fairings.:eek: ...sadly, it lost a battle with a telephone pole:o

Thanks, Brian :) I was beginning to think all Brits were just like those two...:eek:

Happy belated, FoFa

...make the interval portion of the DateAdd() a negative number...

D:\ should refer to the server's D drive. 'client' refers to the client that is currently running the application (actually, a workspace set up by Citrix for the application to run in). The application itself cannot distinguish who's actually running it, because from it's perspective, it is...

Detect the outlook version on startup and establish the correct references. (you'd also need to remove all references on shutdown)

you can't create objects when the form is not in design view. Best way to accomplish dynamic creation of forms is to build the entire form (in design view, of course) then switch to normal view as opposed to adding objects to an existing form. Use the acSaveNo option on close.

All of these are legitimate companies that didn't spend quite enough time considering how their online names might appear ... and be misread. These are not made up. Check them out yourself! Who Represents is where you can find the name of the agent that represents any celebrity. Their Web...

d:\'client'\wine2.mdb denotes the "d" drive on whatever machine you are running the application on. With Citrix, the client machine is only viewing screenshots and transmitting keystroke information (hence the speed of the connection), but the application itself is running on the Server. If...

(extra steps for clarity) Dim fsObject As New FileSystemObject Dim file As file Dim driveLetter As String Dim actualUNC As String Set file = fsObject.GetFile(CurrentProject.FullName) driveLetter = file.Drive actualUNC = Replace(CurrentProject.Path, driveLetter...

you are trying to save to a mapped drive... shift your save path to UNC in the form: \\server\share...

Clint Eastwood -- Fist Full of Dollars You, sir, are a coward. You just shot an unarmed Man! He should'a armed himself.:cool:

if the prefix is irrelevant to the number, i.e. if you have AUD-001 you cannot have PAY-001, you can create the primary key simply by concatenating the pieces you require along with a record count: recNumber = DCount("*",table,"1") + 1 pKey = strPrefix & "-" & Format("000", recNumber) if you...