Search results

I recently implemented barcode scanning to AVOID data entry errors and wouldn't you know it, a new error has arisen. Users are scanning patient case numbers from the patient paperwork to print labels for slides. Here's the problem - when the cursor is positioned in the case number field...

I am unable to open two databases that have been in use for several months. When I double click the shortcuts Microsoft Access opens with an error stating that it cannot file the file, check to make sure the path and filename are correct. The path and filename are fine - I see the files in the...

Ok - found the problem - rather than IsNull([PATIENT]), I just needed Is Null with a space between "Is" and "Null" unlike the string function which is "IsNull".... go figure. So the SQL looks like this: DELETE APWorklistTable.*, APWorklistTable.CASE, APWorklistTable.PATIENT, * FROM...

As for what else queries can do... You can do all kinds of other terrific things with queries like limiting what you see, say you only want to see part numbers produced by manufacturer ABC, use a select query. You can perform calculations like multiply the price of a part number by the quantity...

The easiest way is to use the design view for a query. Under Objects, click on Queries and then click New. Choose the Design View rather than one of the query wizards. A window will open that allows you to build the query from tables, other queries or both. From the tables tab, find the...

I've searched the forum and this must be so easy that no one has ever had to ask .... I'm importing a text file as part of a macro and want to delete the first two rows (records) in the new table. The first row contains text and the second row is all blank. My "cleanup" query has no problem...

I found a solution so here it is.... I used a third query to join the first two queries on the [CASE] field. I also pulled a couple fields out of the second query that weren't really needed leaving only [CASE] and [FirstOfBLOCK]. The IIf statements worked like a charm after I made the join...

I'm using a query to set-up the format for my report. My table has 5 fields: [Case] [Patient] [Specimen] [Block] [BlockNum] A patient may have more than one specimen, which in turn may have more than one block. The blocks are identified as A, B, C etc. The BlockNum's are 1, 2, 3 ... n...

Thank you, I didn't know that - they sure didn't make that obvious on their website.

I dont see references under the tools menu .....

I have a text format operation that works fine on my home PC but not on the PC at the install site. I thought maybe it was a library issue but all the functions are in the library. I changed the following which works: SHORTPAT: UCase(Left([PATIENT],10)) to SHORTPAT...

I'm having a problem using a barcode font.... I've downloaded the IDAutomation code 39 font that has been recommended elsewhere in this forum and I'm having trouble getting letters to format properly. Numbers work fine. I've converted all my letters (last names) to uppercase since I'm just...

Jon, Thanks for the solution. It worked perfectly. Since I was using the Access Design View to set up my query, and Access generated the SQL code, does this indicate that there is a glitch in the Access SQL writing routine ? Thanks again for your input !! Cindy

Here's the SQL: SELECT DISTINCTROW APWorklistTable.CASE, APWorklistTable.PATIENT, UCase(Left(Left([PATIENT],InStr([PATIENT],',')-1),10)) AS LASTNAME, APWorklistTable.SPECIMEN, APWorklistTable.BLOCK, Max(APWorklistTable.BLOCK_NUM) AS [Max Of BLOCK_NUM], IIf([BLOCK]="A",[CASE],"") AS SHOWCASE...

Pat, there are three fields in my query: 1.) [Case] 2.) [Patient] 3) [Lastname] >> Calculated from a function of [Patient] which is of the format of "Lastname, Firstname". Sorry my orginal post must have been confusing. I had several spaces between each of the fields to indicate more...

I set up a query used to create a report. In order to display the data in a desirable format, I've defined a new field in the query and perform some simple functions. When I go to run the query, I receive a message relating to the new field "Enter Parameter Value" where its allowing me to...

Thanks Doc, That goes a long way in explaining the bandwidth issue. My little db has been running in our lab for a year and a half and only has 800 records. We're talking about increasing usage to about 10 times that by having other departments use the system too. So by this time next year...

Thank you for your input Wayne, If I understand you correctly, its not the software (Access) that is to blame for slowing down the network, but the methods employed by the Access programmer to use and display the stored data. With this in mind, (on a high level) what do's and don'ts apply...

I was told by our IT people that multi-user Access implementations are not allowed on our network because they require too much "bandwidth". What is bandwidth as it applies to network applications and is it common for Access to be excluded due to this ? Thanks for your input.

Figured it out... I used the On Change Event from the Facility Combo box to first clear the Department Combo box then requery it. Muchos Gracious !!! This is very cool - my users will love this improvement