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!

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...

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 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...

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...

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

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...

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...

I'm trying to use a query to determine all the individual items in a Bill of Materials. I have two tables: Items and ItemAssemblies. Items descibes all the information about each item including items that are parents of items in the same table. ItemAssemblies only includes three fields...

I'm not sure if this is possible in a query. I have a table of documents and a related table of document revisions. I want to display only the newest revision of every document. Can I do this in a query or do I have to do something in VBA?

I'm having trouble getting a SQL statement to work in ADO that works fine in normal Access Queries. It has something to do with the wildcard in a LIKE statement. Do wildcards not work in ADO or do I have to escape it somehow?