Search results

For what it may be worth, here is the code I have been using in our service database for the last couple of years and I have had no complaints from by boss or has to use ISO dates in his meetings with our German counterparts. I think I got the code from elsewhere in thise forum: Public...

Just did this.....Wow! The difference is huge! Thanks for those instructions. They definitely go in my Access notebook!!!!

I know this topic has been floated around a bit, but I don't see any easy solution. When developing a new projrct or editing an old one, the Front End size grow and can be compressed. I was keeping an eye on it with this last new project. My front end code base got to about 12 megs...

Oh BTW, I printed one of you help messages out this morning and madew the mistake of leaving it in our shared printer too. I got in trouble for printing those boobies out!

Well that took me about half an hour of reading the micorsoft site, copying the chm files. editing the registry but it now works. I did have SP-3 instlled, but nor SR-1a. I thought Service Release verses Service Pack, maybe two different things so I tried following the microsoft links to...

I didn't see the scroll bars either when it did this for me. I usually just click on "Window->Cascade"

By the way... one more thing... I wish my help were as good as yours. When I did find the command in help (wasn't there at first), it only shows it in a list an no explanantion of how to use it, the way your help file appears to. It there a more advanced help that I can install? I am...

Well, it would not even auto-complete the syscmdInitMeter.... So I gave up and added another routine that required me to add a reference, I think it was "Microrsoft Scripting Runtime" (not at program right now). Later last night (or should I say this morning), I revisited trying the progress...

I guess it isn't available in Acces2000:(

After a bunch of fooling around, I tried this and it worked: Graph_Data.Axes(2).MinimumScale = (AVGMin / 100) - 0.05

If you have a chart in a report, and VBA code acumulates data that would go off the pre-set Y-AXIS scale of the chart, is there anyway for that VBA code to change the Y-AXIS Scale Minimum? On a scale of 0% - 105%, the majority of my data is condensed around 80% +/- 20% so I have the Y-AXIS...

Hello Bob. I use Access 2000 exclusively as we do not have Access 2003. I always open tables like this: dim rs as recordset dim db as database dim strSQL as string ' strSQL = "Select *......... set db = currentdb() set rs = db.OpenRecordset(strSQL, dbOpenDynaset) Is that a bad/archaic...

Hello Bob. I use Access 2000 exclusively as we do not have Access 2003. I always open tables like this: dim rs as recordset dim db as database dim strSQL as string ' strSQL = "Select *......... set db = currentdb() set rs = db.OpenRecordset(strSQL, dbOpenDynaset) Is that a bad/archaic...

I solved that a few years ago, by having everyone load the database via a batch file on their desdtop. Works real well. The batch file loads a fresh copy off the network to the d:\service directory and then runs the database frontend from there. The system.mdw still resides on the network...

If they don't want to sell me a MSCOMM32.OCX package, I can always make a requirement that VB6 is installed on the testing system. Probably most of techs will already have that already since this isn't the only automated procedure we have. The rest are in compiled VB6 programs. I haven't...

Has anyone in this forum ever used the Agilent GPIB interface API with VBA? I would like to know your experience with it.

Here is from Microsoft: Hello David, Thank you for Contacting Microsoft Online Customer Service. I understand from your e-mail that you would like to know whether Microsoft provides an installation package for MSCOMM32.OCX for Access 2000 without installing Visual Basic 6.0. I recommend that...

I have built an automated procedure in VBA Access 2000 that is now great (thanks to a lot of downloaded help from this forum). I use the MSCOMM active-x control to talk to an instrument via the serial port. Question: Is that control only working because I also have VB6 installed on this same...

Hello Fen How, I do something similar. I take my database mobile and make changes, record additions, etc in the field. When I get back to home base I want to upload the field created records to the main database. Here is a code I use in one of my simpler databases to do that. You of course...