Search results

Hi All -- I've tried to find the answer before posting this. I have a form that I can view in Design view and layout view just fine. BUT -- If I just try to open the form in from view, it disappears somewhere even though it says it's open. If I view it in Layout view first, then Form...

Thank you for the suggestions. I already set the recordset to New.ADODB. I can iterate through the recordset b/c I write it out to a local table. But, I added the loop code provided which it did fine, but when I then tried to rst.MoveFirst, I got 'rowset position cannot be restarted'. I'm...

I actually did. I tried a whole bunch of variations. It's really weird...I can't figure it out

That doesn't work. I get a -1 which got me searching for an answer. I found that the cursor is defaulted to forward only therefore, I needed to change my cursor type. But, it still doesn't work.

I've found the same answer all over the place but I can't implement the suggestions and have my code work:mad:. Can anyone see what I'm doing wrong? I really just want to get the recordcount of the recordset to display on my form. Public Sub CallSP() Dim cnn As ADODB.Connection Dim...

I figured it out. I had a filter on one of the fields in the properties and Even though I had filter on load set to 'No', when I filtered on the datasheet, it set the filter in the property of the detail subform. I removed the filter in the properties of the detail form and it works fine.

This doesn't happen on all my other Frm/subfrms that I have. Only this one and I can't figure out whey. I have a main form with a datasheet subform and a detail subform on it. The detail subform works fine until I filter on the datasheet. Both forms use the same view. But, when I...

I have an Access DB that I have lots of VBA code behind the forms and a few modules. Currently, I create an Access accde for the customers instead of distrubuting the whole database to everyone. They download the frontend piece to their desktop and they can run reports, enter data against...

I've gotten a little further in that I can clone the recordset but it's saving the full recordset instead of the filtered. I'm using the DoCmd.TransferSpreadsheet and have tried putting the rst in as the source and also rst.Name. Using rst gives me "An expression you entered is the wrong...

I've been trying to find examples on how to grab the recordset after a user has filtered a datasheet and export it to EXCEL with VBA from a Button on a form. I've figured out how to export a pre-defined query to excel with all the fields I need. I was hoping to be able to grab the filters from...

I have a form with a source linked table which is a view of multiple tables in SQL. I know that ACCESS can't update records to a linked view that has a join of more than one table. So, in the BeforeUpdate procedure, I update the tables directly via a stored procedure call. But, then, the...

The whole point is to make the interface collapsable, expandable depending on if the user wants to see each group. For this particular app, it's to shift fields up when hiding objects

Thanks. I actually started going that way I'd also like all of it to display if they want it all and with a tab group, then that wouldn't be an option. Good idea though. Thank you

Hi All I am building a form where I would like to group fields into 3 groups, A, B & C. I know I could put all groups on their own subforms but I'd like to see if there is a way to simplify it all on one form since there aren't much fields for each group. I would also like to hide each...

Hi need HELP! I have a subform based on a linked table that is to a SQL view. I found yesterday that if the SQL view has more than 2 tables joined, you can updated the linked table. SO -- I need to do the update manually. What is the events I need to put the update statement under when the...

So what is the event that you would put the accmdrecordsave in? I'm assuming, if I had a form, and the form had multiple fields to enter information, upon leaving the record, it should run an update query or the referenced command but would event would that be under? And if its a subform, would...

Hi All I'm pulling my hair out. I'm SQL Dev with limited Access Dev. I have an Access Db with a SQL Backend that has been given to me. In the Access Db, the previous Dev created linked tables to views in the SQL and forms with subforms referencing the view. I can see why he did a view...