Search results

For certain user types, I want my startup form to open another form. I'm doing this from the Open event, and it works fine, but the startup form still ends up on top of the 2nd form. I suppose this is because the startup form events don't finish until after the 2nd form is open, which brings the...

Hi April, I posted a question yesterday that has received no response. Does that mean I stumped everyone, or was my post just to boring :) I don't want to annoy people by re-posting. Any advice?

Why don't you just make your tables' primary key an autonumber?

I'm trying to utilize code from 2003 in a new 2007 database that compacts the db in the Form_Close event if there are no other users logged in. Here's the code: Private Declare Function LDBUser_GetUsers Lib "MSLDBUSR.DLL" (lpszUserBuffer() As String, ByVal lpszFilename As String, ByVal...

Well, I got it working, even though I don't have an explanation for why it didn't work. I started by making a copy of the database, then stripping out everything unrelated to the issue -- all tables, queries, forms, reports, and modules, except for the two tables and forms (main form and...

Rather than upload the database, which is fairly substantial, I decided to create a small sample one. However, that one seems to be working correctly, so I'll do some more research and let you know if I find anything. Thanks much.

It is an mdb. I have already done as you suggested. As stated in my previous post, the problem is not with acLast. It appears that the acNewRec command doesn't occur immediately, as it does in 2003, but waits until the Form_Load event is complete, but by then my code has already updated the...

It's a fine discussion about acLast, gentleman, and I appreciate the replies, but that's not the issue, as that part of the code is working fine. The problem is with acNewRec. Thanks for the suggestion about acCmdRecordsGoToNew, but unfortunately that has the same results -- It works in 2003...

Greetings. I have a form that automatically creates a new record each day, the first time the form is opened that day. Code in the Form_Load event checks the date value in the last record of the table, and if it is less than the current date, it creates the new record. Otherwise, it stays on...

I HAVE A SOLUTION! In the example I had provided, in the MainData1 form the row source for SubCatID is qryCat_SubCats. I did the following: Made a copy of qryCat_SubCats & called it qryAllCat_SubCats In the new query, deleted CatID (which was being used for the cascading criteria value)...

Yes, that makes sense. The requery causes the control value to be blank in records where the query (record source) doesn't return a value based on current record. But still, if this is true and there is no solution to the problem, why would anyone ever use cascading combo boxes? I guess the...

Dude, I know that. I wrote the code (see the last sentence in my post). (Also, please reread the 1st paragraph). I would really appreciate some help on this. Thanks!

Greetings. I have searched the posts and seen this issue brought up several times, but have not found a clear answer. It appeared that the respondents possibly didn't clearly understand the issue, so no offense, but I'm going to try again. In a form with cascading combo boxes, why does the...

That's all good help. Thanks each of you. Another question: Is the space required for a text field base on the defined field length or the actual value in the field?

Could someone provide some general guidelines as to determining the most efficient options for field lookups (value list vs table)? And in the case of a table lookup of a text value, at what point would it be more efficient to switch to having your field and lookup value a two-column lookup...

Sorry. Formatting on previous reply didn't come out right. "x"s should be under the Mon and Tue columns.

I thought some sample data might help clarify: Class Definitions table: ClassName Mon Tue Wed Thu Fri Aerobics x MS Access x Daily Classes table: ClassName ClassDate StudentName Aerobics 5/5/2008 Joe MS Access 5/6/2008 Mary

This is a general suggestion without taking several pages to provide all the details. Try creating two class tables -- one for Class Definitions and one for the Daily Classes. In the Class Definitions table, have the class name, a boolean (yes/no) field for each day of the week, and any other...

I have a couple of forms with queries as the data source that sort the data several levels deep. If I sort the data on the forms, they retain the new sort sequences, even if I close and reopen the forms, or completely close the database. In the past, I thought Access would ask if I wanted to...

I found my question on a previous thread (2-21-2008), but am unable to get the answer to work for me. I have an unbound form with several textboxes to receive search criteria (loan number or customer name), and a couple of subforms to display the requested loan and customer data. They want to...