Search results

Maybe if you calculated DMax("[MeasurementDate]","Rafa Update Sheet","[R/B]= '001-03'") and stored it in a date variable called dtmMaxMeasurementDate Then did your next calculation like DLookUp("[Psi Final]","Rafa Update Sheet","[R/B]= '001-03'" & " And [MeasurementDate]= #" &...

Access Hero, which way would run the fastest?

Gotchya, That definately works. I added the following column in a query; OTHHoldType: Mid([TransactionNote],((InStr(19,[TransactionNote],"from ",1))+5)) It returns everything after "from " every time. I chose to start the InStr search from the 19th place, because an order number cannot be...

The word "Order" is always in the same place, but the word "from" can variate based on the length of the order number (represented by XXX above). Would InStr still work in this case?

I have a database that I do not own, but I need to run a report on. One of the columns is called TransactionNote and contains text like this; "Order XXX released from PAY TYPE" and "Order XXXXX released from PRODUCT INFORMAT" What I need to do is split out the text in caps. Then we would have...

Okay, here's a revised example with the changes above. It'll take some time to apply these changes to the full FE. (The example is just a VERY stripped down version). I'll let you know how it goes.

AH, thats genius. I'll give it a shot.

Yes, sorry I forgot to mention. tblIncidents has 20k records, but right now I am only applying this functionality to a form that limits the records to incidents that the user created themselves and incidents that they currently own. I don't think any user would have more than 500 records in this...

I am currently trying to apply conditional formatting to a continuous form that typically has thousands of records. Unfortunately it is a lot more complicated than you may think and requires a little background before I can address my real problem. I'll do my best! My idea is very similar to...

I think you may have to write your own functions. for instance, in one of my largest databases I use the API "fOSUserName" in combination with three tables. tblGroups and tblUsers and tblUserPermissions. Users are part of one or more groups. The groups table holds default permissions for each...

That's a good one... Every man's dream! ... and woman's dream probably! Anyway. I just joined a market research panel and they might be sending me a barcode scanner to use in my daily shopping. Sounds like a good candidate for some reconfiguration for this database! Anybody remember CueCats?

That should be just fine. One more thing you might want to do is keep the master front-end on the network and give each user a link to a batch file. What the batch file would do is copy the master front-end to the c:\Database drive whenever the user clicks on the link. This would allow you to...

I would avoid mapped drives like the plague. As to your question: The best place to deploy the FE... Did you mean each user has their own computer, or there's only one computer and everyone uses it?

Normalization is a great idea 99.99999999% of the time. Based on your response, I have a feeling you need to do a little more research. Here's a quote from the first posters link: My intent is not to scare you, rather I'm just saying "first-things-first". For me, all the books and articles...

I know this is a little old, but I'm not sure if you ever got this working. When you say; Are you referring to the .mdb file itself or the parent folder where it resides? This almost sounds like you applied Full Control to the file but not it's parent folder. You HAVE to give full control...

What version on Access are you using? If you're using '03 there is a setting in: Tools -> Options -> Edit/Find Tab -> "Default Find/Replace Behavior" This might be what you're looking for.

SOS, would he also need to requery the form?

Download OphCrack

I agree. Almost everything that people disliked about XP and Vista, Microsoft has greatly improved on with Windows 7. I too have been using it as my main OS (with external storage for anything important of course) and I don't have any complaints.

As you can see in my example, I added a table for UPC/EAN codes. Even if the user doesn't have a barcode scanner, it can always be entered manually, or the user could select the general ingredient from some cascading combo boxes tied to the ingredients table. The UPC/EAN table relates to the...