Search results for query: *

Is there a way to determine what record selectors someone has selected in VBA? I know you can determine the current record easily enough, but what if someone has selected multiple record selectors on a continuous form? Thanks!

Also, I will get other errors when accessing "frm.dirty" during the closing of a form for other reasons (and most of the time I'm not sure why, the example in my first post is the only time I can consistenly generate an error). Most of them give me the error: Run-time error '2455': You entered...

I don't use any macros in this database. And yes, I can catch the error, but why isn't giving me a more specific error to catch? Thanks!

I am in the process of coverting a jet MDB to an Access Project in SQL. I've noticed some weird behavior in regards to saving data on a form. My forms are closed using a command button that basically does this: If frm.Dirty Then frm.Dirty = False End If DoCmd.Close acForm...

I am in the process of coverting a jet MDB to an ADP. I've noticed some weird behavior in regards to saving data on a form. My forms are closed using a command button that basically does this: If frm.Dirty Then frm.Dirty = False End If DoCmd.Close acForm, frm.Name This...

Thanks JonFer! I had to re-read both of your posts a few times before I understood what you were saying! This worked perfectly! Would be nice if I didn't have to have so many queries, but it works! Thanks, Patrick

Let me try to explain this better. I'm not tring to do a union query. I'm basically trying to get the exact output I stated, but with all values and not just the ones that are in both queries. Currently I am doing this with two inner joins between both the Month and ItemName fields on the two...

I have two queries that I am trying to combine: Qry1 Month ItemName Quantity 04-01 Item1 10 04-02 Item4 12 Qry2 Month ItemName Quantity 04-01 Item1 75 04-02 Item2 4 04-02 Item3 8 However, this is the best I can get: Combined Query Month ItemName Quantity1 Quantity2 4-01...

I've seemed to be able to do this using two correlated subqueries. But I'd welcome any other suggestions!! Thanks! Patrick

Thanks Lespaul! You seem to have me in the right direction, but I'm still not there yet. qrtTotals did not return any results. When I removed the PackageComponentID field from the first two (this field is the primary key, so it was not aggregating the function correctly) and joined these two...

I need some help formulating a query. Here is the table structure: Package Components PackageComponentID RequestID ProjectID ItemID Quantity Each record in the table will either have a RequestID or a ProjectID, but never both. I want to get the sum of the quantity for each item and separated...

Thanks nicsin! I thought I had tried something like that already and it wasn't working.

I'm having trouble creating a query that will select the newest record in a related record. I have a table of items that have related records in the table "StockTake". StockTake contains 3 fields: ItemID StockTakeDate Quantity Basically, I want to select the record in StockTake that...

This doesn't seem like a terribly difficult question to answer if somebody knows the answer, so I'll try to explain better and hopefully I'll get a response this time :-) I'd like to change the view, like "datasheet", "continous form", "single form" from VB. The...

Like Single Form, Continuous Form, Datasheet

How can I change a subform's view programmatically? I tried changing its defaultview property but it won't let you do that. :-(

Thanks for the reply, but I tried that already. I just imported all the changed objects to an older backup and I think everything is working now. Unless anyone has any input as to why it was crashing I think this thread can be closed now. Thanks again!

Okay, Weird crashing problem here. I have a database that after I open it, nothing happens. Access opens and prompts for my username/password (the database is password protected) and that's it; the database window does not come up. The majority of the menu items are greyed out, although I have...

Currently I'm manually doing it with a joined query and the .addnew method. It seems to be working fine. I was just hoping there was a better way. Thanks for the info!

I'm trying to insert records into one side of a many-to-many join but I can't exactly figure out how to do this. I know how to add records using INSERT INTO and ADO, but is there a way to get Access to automatically insert the correct data in the "intermediate" table used to make the...