Search results

I have a query which, for the purpose of generating our company's bills, creates an enourmous recordset. Most of the data comes from the Charges table, but there are 3 other tables involved here. The problem is, I want to have every charge show up in my query, even if some information is...

The only joke I know Well this is the only joke I know, apologies if I offend anyone :) What is the smartest thing to ever have come out of a blonde's mouth? Einstein's c*ck!

Thanks a lot, man. I am going to try this out. We don't have SQL Server, however. The users have local front ends with a shared backend (Access 2002). It's got to be faster than DLookUp, anyway. Ed

Thanks, that did it! I know DLookUp is slow, but I've got about 50k file numbers and about 10k client numbers to validate from. Do you have any other suggestions? Ed

I've got this code so far: Private Sub FILENO_LostFocus() Dim msg As Integer Dim compare As Variant compare = DLookup("[FILENO]", "tblFiles", "FileNo = '" & Me.FILENO & "'") If IsNull(compare) Then msg = MsgBox("You must enter a valid filenumber!", 16)...

What can I say, my users are idjits and so the boss is requiring the following of my db: There is a form used to enter charges. The first two fields are FILENO and CLIENTNO. What is the best way to a) ensure that each number exists in their respective tables before accepting the entered...

The link worked for me! Thanks

I agree with MaddMaxx and Mission. I'm new to the access scene (never even used it before Jan '03), and using a couple of books and lots of browsing forums like this, I managed to create a multi-user database with almost every spec the boss wanted. Get help for SPECIFIC problems here...

I installed an mdb with access runtime on several machines here in my office, and each person has the ability to select printers, but only if you set up your macros or code to "print preview" the report. The user then must select print from the file menu, etc. If your macro (or code) is set to...

I was just reading Ms KB 283849, which indicates that a network data collision or perhaps faulty hardware (card, cable, etc.) could be the cause of the corruption. We are getting a new server in about a week or so, but if a user's machine is causing the problem, I imagine that we'll still...

Here is 8749-8753, taken from teh backup done on 9-15. 8749,9/5/2003 0:00:00,"58582.s1",1,,,,,600.00,,,200.00,3.00,,"DEL","Prepare Clearance Opinion","4665.0","DEL","A",,,,,,,,,0.00,0.00,,, 8750,9/5/2003 0:00:00,"58481.S1",1,,,,,150.00,,,200.00,0.75,,"DEL","Prepare Patentability...

Thank you all for your support. On a whim, I tried exporting the table as ASCII delimted text, just to see what turned up. ALL OF THE RECORDS WERE THERE!!! I copied my table structure and imported back into the new table, and it appears that I haven't lost anything. Does anyone know why this...

I have been seaching through the text trying to determine how access stores its data. It appears to separate "normal" fields from memo fields. The memo fields from the lost data appear present, but I am unable to determine where their corresponding data resides. Also, numerical values are...

I put a fresh install of access on a box that is off our network. Then I extracted the .mdb from last thursday's backup. I copied that to a cd-r and physically walked it over to the box with the fresh access install. Upon opening that .mdb file, the number of records is still at 8750. I...

I tried the compact/repair and import -- no luck. Next I tried opening up the .mdb from the backed-up file with a text editor. Amazingly enough, the text from the missing records is there! Why can't access see it? I really am pulling my hair out on this one.

Thanks for the suggestions, guys. The query for the report comes straight from the Charges table. We first noticed the problem in the form for editing individual charges, when after the compact/repair we were not able to pull up any of the records we were working on. This led to further...

Pat, Well, the table missing the records is the first place I looked. The records run from 1 to 8750. My user ran reports yesterday which show records up to 9600. Incidentally, the .mdb file is extractable from the backup, but I tried Fri, Sat and Sun -- no sign of the missing records. I...

800+ missing records!!!! HELP, PLEASE!!! I just had some of my users report a back-end corruption. It seemed like no big deal, until she went to see if the last edit she made was there. Well, turns out we're missing the last 800 or so records that were entered. No big deal, I thought, we...

Thanks Rich. I looked up Nz and it was just what I needed. I also had to change the name of my control, but it to works now. Ed

Pardon my ignorance, but could you please elaborate? What is the Nz function? Ed