Search results

Okay, seems like the table will not work. I was hoping to use it to pass the table values as parameters and have it loop through the table parameters and run the report based on the parameters. But, sounds like VBA is the best structure. If I find out something different, I'll post it here...

I don't know for sure, and maybe I'm stuck with just using VBA. But I was wondering if a table would work, like this. there are 12- 15 rptArea and each area can have 1 or more reports rptArea rptName strdisplayName strReportName Execute Report Code Mktg Mktg1_rpt MKtg1 strdisplayName...

humm... The client wants a button to click on. Then the code would do the processing. I have the VBA, but I think there is a better way to streamline the code. But need help. Thanks, Ben

I found something for recordset. I can still set up a local table, right, and just use the one recordset routine?? Here's what I have in draft version: if rptArea is "Mktg" then Call GenerateReportsByrptArea End if Sub GenerateReportsByrptArear() Dim rs As DAO.Recordset Dim...

The Access database has a SQL backend with tables, views, SP's. I have reports to run based on rptArea and I am currently using vba but wondering if it's better to use a report table. For instance, sample vba code: if rptArea is "Mktg" then Case M1 rptName = "Mktg1_rpt"...

I'm trying to step through VBA code to look at the data that is being created. How can I get the output of a VBA select statement to show it as I step through the code? For instance, a select statement sSQL="SELECT ........ Is there a way to create a quick #Temp table that takes that vba...

You are right. I was looking in the wrong place. I found it and was able to unlock it and copy the forms to another database. Thank you!!

accdb

I inherited an Access database that is password protected. I can open it, view tables, queries and forms. But, when I click on a form event to see the code, I am prompted with enter the password. I do have the password, and it works. My issue is that I want to copy the forms from this database...

This works perfectly! Exactly what I needed. Thank you for your quick response. Ben

Arnelgp, I see that I didn't explain it well. The button on my form is a delete button. I want to delete only one(1) of the three parts. for instance the (6)388108, from the textbox. I know and have saved that the qty is 6 and the part is 388108 when I click the delete button. I see how you...

Sorry, concatenated data with a textbox. It's an MS Access textbox where previously, the data was put in the textbox in a string to add multiple parts and quantity. Now, I have a button on the form and want to delete certain ones from the textbox. Leaving the data concatenated for the remaining...

I have a form with a concatenated textbox with string information separated by a comma. Example: (2)01-1210,(6)388108,(4)75342 (2) within the parenthesis is the qty, and the remaining number is the part#. There can be a string one or more of this qty and part # separated by a comma. When I...

This issue is solved. I managed to tweak the code and got it work. Thanks again.

Clarifying: For each vendor, group by fixture category in column "U" - Thanks.

I see what happened. On output to Excel, it lost the group by fixture category in column " U". Is there a way in your renumber routine to group by column "U" first before doing your renumbering? The renumbering is working, but we need to group them so the onChange works better. My apologies for...

Database is huge and connected to SQL. I like your idea of a report. I will try it although they prefer to see output in Excel format.

I tried the code but it did work. Made it worst actually and deleted the vendor list from the main form. Still trying to find a solution.

I inherited code from another developer. The code works fine to export to Excel as shown in CurrentOutput.jpg example. But, now they want to break up the output to filter by fixture category. When the fixture category changes, then write out a new header row'(see example attached on...