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

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

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

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

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