Search results

Great feedback Stopher. Actually, I don't have the form bound to a table as I don't bind any forms to table or queries, I handle all data traffic through the VBA in all of my projects.n I know this is a silly platform to design this kind of game, but it was more of a 'I wonder if it can be done'...

Thank for the feedback Galaxiom. i'm not calling anything 'Property', that's just asking for trouble. And I also have protocols for saving the session after each move. right now, all real estate values are saved in a table (Owner, Name, Building Cost, Rent Per Building, Number of Buildings etc.)...

I've been an Access VBA developer for over a decade, but I'm working on a project and trying to utilize some class modules. You know, just for kicks. However, I'm having a hard time finding the value of incorporating a class for a specific idea, and would like some folks to give me feedback, as...

No problem. If you need further help, give me a shout. ~R

What I do is add an unrelated table like 'tblAdminString'. this table has two fields, 'StringName' and 'StringValue'. Then your DLookup would be something like: DLookup("StringValue", "tblAdminStrings","StringName = 'AdminPWord'"). ~R

Bear with me for my thought foundation here. You would need to have a master 'Subject' table in order to retain all of the viable selections, a 'Student' table, and one additional table would be a 'StudentSubject' table. With this foundation, a student would come into the form for the first...

I agree with Bob. In an internal situation, it would probably take a grand total of a week before the hard-coded password was common knowledge. This leads to having to communicate the new password, revising the application etc., which is tedious, to say the least. A table that holds the...

Happens to the best of us. Glad you worked it out. ~R

I'm pretty sure you will at least have to go the route of a macro, if not a code snippet form the 'Before Update' event of the check box. Macros aren't my playground, but here's a code snippet to accomplish what you want. Private Sub chkTEST_BeforeUpdate(Cancel As Integer) If InputBox("Enter...

So, latest update. I tried to format the boolean field as [Field] & "", and I also tried [Field] & 'TEST', then crited it for '-1', '-1TEST' etc., all with the same result. Even when they put the linked table local, it still had the same issue, but it does not on my dev system. I wound up...

You know, as I think about how they source table is created, you may be correct about the string field. They actually have a 'Date' field that has values such as 1072009, which is kind of hard to parse out for a query. I'll try your original suggestion, hopefully tomorrow as I've got to be...

It could be a screen refresh issue for the random changing, but that doesn't account for the false records showing up. I found this issue because I had original query string thrown from VBA. My dev system returned the correct number of records, but their internal system brought back too many...

Actually no. It's from the raw field.

I'll give that a shot. I noticed something else odd with the table. When I go into the query results and change the boolean field focus from one record to another with the arrows keys, the value in the fields changes from 0 to -1 or vice-versa. If I hold the key down or up, the values will...

Thanks for the reply Bob. I actually tried the criteria '<>0 AND <> FALSE AND <> NO', and still got the 'untrue' values. It's really starting to get on my nerves.

Greetings all. Came across an odd situation today in troubleshooting an Access solution I created for a customer. They have a server resident dBase table that is linked into the Access solution. When I create a query based on this table and tell the boolean field to only return 'TRUE' values...