Search results

The summary report shown in the image you attached seems to involve a complex of info not found in the uploaded .MDB table. In other words I don't see how the table even provides all the kinds of data necessary to produce that kind of summary report. Care to clarify?

I don't understand. Can you provide the "big picture" as to what you are trying to accomplish?

I'm not sure what you want. Here's some possibilities. This one gives a count of true and a count of false. SELECT OnParade, Count(OnParade) as OnParade_Count FROM tbl_Attendance GROUP BY OnParade This one gives a count of all Trues/Yes SELECT COUNT(OnParade) FROM tbl_Attendance WHERE...

I had created this version of the query for data validation (and since then relied on other means to validate it). If only I had seen your solution earlier !!! But many thanks - you can see from my frustrated posts that the whole issue was maddening to me. I'll add your solution to my notes.

If i understand correctly you are changing which table is in the FROM clause. I had already tried that even before I started this thread. Good suggestion, though.

All columns are indexed, in both tables. That's precisely why single-table lookups are running so fast. I'm no engineer, but I would have expected Jet to somehow optimize this join, given that the WHERE clause is only pulling basically one record from each table (well, one OrderID, at any...

Does Jet do joins efficiently? I have a Jet database packed with 10 million records (account numbers) ,and I'm very impressed how fast a user can look up an account number. On the other hand I was surprised by the following scenario. I have two tables (let's call them Customers and Orders to...

This doesn't work either where cint(fac) > 300 Nor does this: where Cdbl (fac) > 300 All the above generate the datatype mismatch error.

Ok, this is pure insanity. Just to make sure that we're dealing with pure numbers here (no letters or punctuation), I nested the query three levels deep. The innermost query guarantees we're dealing with pure numbers here - and just to make sure, I created a small sample table with only two...

I'm tempted to think that IsNumeric is failing to do its job here?

This should be a simple query (this is a one-table query with no joins), but I'm getting "DataType Mismatch in Query expression." Here's the deal. Our account numbers are generally 13 digits long. The first three digits constitute the facility number (FAC). All I'm doing is extracting the first...

Microsoft says "To open a database by using exclusive access with DAO, set the Options argument of the OpenDatabase method to True." http://msdn.microsoft.com/en-us/library/aa141813(office.10).aspx But it doesn't seem to be working for me. I tried these ways: DB = eng.OpenDatabase(pathToDB...

I can't figure out how to open an .MDB file in exclusive mode using C#. For example I've tried this: object oMissing = System.Reflection.Missing.Value; DAO.DBEngine eng = new DAO.DBEngine(); DB = eng.OpenDatabase(pathToDB, oMissing, true,oMissing);

Two lines of code look suspicious here. First of all, you're using an empty string (see the red below). Hold = Replace(Hold, ";", "") You're supposed to be inserting a blank space because the Split command splits on spaces. Hold = Replace(Hold, ";", " ") Secondly, you're supposed to be...

Ok attached is a sample. You'll see that the "EmailAddresses" table is initially empty. But when you click the button on the form, the code populates the table by breaking up the long email strings into individual emails. Maybe that will get you started.

Thanks for the info. Unfortunately I can't install the Access runtime on these machines because I don't have permission. Maybe I can migrate this project to an SQLite database.

As an experiment at home, I tried linking a local .MDB file (I guess this would be the front end) to a remote Access .MDB file (apparently this would be the back end). But this action created an .LDB file at the back end. This works fine at home, but it would fail at the job for lack of...

Hmm....Come to think of it, I do seem to recall hearing that DAO can be used to link tables even without the Access runtime installed. Ok, I guess it's time for me to start learning about linked tables - I'll do a search. Thanks!

Thanks for the suggestion. However, I'm not sure that linked tables is an option. The users don't have the Access runtime installed (I don't have permission to install it). I am using C#.Net to drive a Jet database. With C#, I don't need permission to install anything because nothing needs to...

You can have a separate table called Emails (2 columns shown below). For example this employee has three email addresses EmployeID.......EmailAddress 12345.............john@yahoo.com 12345.............john@hotmail.com 12345.............john@gMail.com