Search results for query: *

When ZoneAlarmPro 3.1.395 is running, Active Directory won't work - get message 'The network path was not found'. When I stop ZoneAlarm, AD runs again. Am not sure which program runs AD to set this up in ZA. Also I can't get my 2nd machine (win2000) to access the internet - with or without ZA...

In the rebuilding a client computer I inadvertently gave the machine a different name. I want to rename the machine back to it's original so that the users can access their profiles. But the server gives the message that I can't rename the machine because it is already in use. Is this a...

Hi there, In an Access97.mdb I had a button on a toolbar which, if clicked, would toggle through opened forms. It ran from a macro - SendKeys ^{F6}. This useful little function doesn't work in Access 2000. Any ideas on either SendKeys in Access2000 or code which will allow a user to toggle...

The following code is supposed to show date in a search function. strSearch = "[" & fld.Name & "] = #" & Me.Date & "#" It sort of works but not correctly. My date format is UK ie. dd/mm/yy. If I enter dd/mm/yy into the 'Search for' box it says there are no...

I have a street field and want to be able to strip the number and leave the street name only. eg. 124 Smith Sreet would become Smith Street. I can't use Left$ because the number preceding the street name could be 1 character or 6. Any ideas appreciated

I have inserted pictures into a form thanks to DougP's code. I now want to be able to print out the record. Using the same code on the report was unsuccessful. Each record has an ID and each record has a picture linked via Dougs code. I can get the OLE Object format to work but not an Image...

Is there a way to close an opened back-end 97.mdb located on a server in order to compress & backup the data tables? Thanks

The following line works fine in Access97 but in Access2000 I get this error: Run-time error 2455. You entered an expression that has an invalid reference to the property Input Parameter. The line is: DoCmd.DoMenuItem 7, 0, 2, , A_MENU_VER20' Save Report. I guess it's something to do with the...

Is there a way to change the standard Record: 1 of 100 at the bottom of a form to eg. Client Record: 1 or 100. Thanks in advance

I have a table that stores hearing aid service records. One aid may be serviced several times and then at some point it may be written off. I have a Y/N field of 'WriteOff'. If the last service resulted in a 'WriteOff' then I want all previous entries for that particular aid to also have it's...

I am thinking of purchasing an .mdb from a supplier - with full source code. Their price is $100 more for the Multi User version than the Single User version. I can't think of anything which would prevent one from using a 'Single User' version across a network. Am I wrong? TIA

When I apply a filter on a form I get the above message after scrolling through 26 records. This is a new one to me. Any ideas why? TIA

I am extracting a range of info from one table to produce a number of reports. The database is networked with the table on the server in the back-end. Should these reports be based on the table or on a query which is in the local front-end? Thanks in advance

I want my form to appear on the top right of the screen everytime it opens. Any Ideas? Thanks

I have written a help file for my Access97 DB. (*.hlp and *.cnt.) I can't figure out how to call it from the custom menu bar. All attempts to call it from a module or macro results in either nothing happening or my getting the default Access help file. Any ideas appreciated.

My form includes calculated fields - Time, Labor, Part Cost & Total Costs. At the moment time is entered as say 1 or 2 or 2.5. Then Labor is calculated as [Time]*65 ($65.00 being the current hourly charge out rate). Then Part Cost is entered. Then Total Costs is [Labor]+[Parts_Cost]. I have put...

I want to change the font color of a field if a certain condition is met. The condition is: if tbl1.field1 = true then tbl2.field2 fontcolor = red otherwise tbl2.field2 fontcolor is black. This looks straight forward but tbl1.field1 is on a subform and tbl2.field2 is on a second subform - both...

I want to unload Access2000 and install Access97. Are there any traps I should be aware of? Is it as simple as uninstalling Access2000? Can they both exist on the same hard drive?

The following code converts a name to sentence case: LastName = StrConv(Trim(Nz(LastName)), vbProperCase)<br>It works well. But sometimes part of a name should be in lower case especially some of the northern European names like van Dyke.<br>Is it possible for the code to operate but to be able...

Each record includes 8 number fields which contain audiological results. 4 fields refer the the left ear and the other 4 refer to the right ear. <br>I want each client record to show, on the main data entry form, a small graph which shows the audiogram - maybe a line graph with one line showing...