Search results

Hi Simon, I'm sorry but I don't understand normalized :)... There are headings (field names) from 2 separate tables in the comboboxes (on my Form "CustomReport"). They define what the page header labels are in the report ("rptCustom"). I am trying to sort by the left-hand column, but because...

Is there noone that can help me please?

What I did was import the excel files into tables in Access, then I created a Form with 7 comboboxes populated with the headings of my tables (ex. Name, address, ph#, manager, job title, training course, duration, etc). Then I put this code behind the Form command button ("Make Report") allowing...

Can anyone help me out please? I have the following code that makes a report from comboboxes in a form, but I am unable to sort by the variable field. What do I need to add to this code to have it sort by "lblfield1"/"tbfield1" ? Thank you, Nicole :) Private Sub Command54_Click() On Error...

Thank you for trying to help out :)...I've got the report working now, just a small formatting glitch left to figure out.

Dear Akram, I have managed to put together a report using VBA, but it only allows the user to print the report form, not export into excel. What are you trying to build exactly?

Thanks Gizmo...I hadn't thought of that :). I need to keep it simple though...as it is set up now, the user can print the report they design with the form. As I am dealing with a bunch of sales agents across Italy, who have even less knowledge of Access than I do :), I would prefer not to...

Dear All, I have built a form that contains comboboxes allowing the user to choose what they would like to see on their report. Below is an piece of code that takes the choice of the combobox, and puts it in the report. What I need help with is how to set lblfield1/tbfield1 as the value to use...

Hello again... I managed to get this working using the module below, but I have some formatting problems and "Enter Parameter value" messages. Because I am using data from 2 tables, my headings are coming out as "Personnel Data.Employee Name", "Training Data.Course Descriptions", etc....is...

Thank you for your response :)... That doesn't work so well...what it gives me is the field heading (repeatedly) rather than the actual data under that heading. ex. the Field List from my Personnel Data table is: Employee Name, Address, Phone, Town, Province, etc. What I need is the data not...

Dear Modest, did you ever find a way to make custom reports? I have built a form that contains 8 comboboxes populated with field lists from 2 tables. My intent is to allow the user to custom make a report based on the headings they choose in the form. Any help would be much...

Dear All, I am building a personnel/training database and has been going well until I attempted to create a form which allows the user to create custom reports. It contains 8 comboboxes populated with field lists from 2 tables. These are to allow the user to choose which headings appear in...

Dear All, I am building a personnel/training database and all has been going well until... I created a form with 8 comboboxes populated with field lists from 2 tables. These are to allow the user to choose which headings appear in their Report. I found a module online, edited the form and...