Search results

I need to send a report via email. I only have runtime access 2003. I only have a print option not an export option. Is there something the developer can do to get me an electronic copy of the report on her end before she delopys the runtime? Thanks Deb

I am teaching an Excel 2007 class tonight. I was reviewing the exercises for Macros and got the error messages. The recording is simple. I click on the bottom left the record macro button, type in the name and the create my sheet with headers and formulas. I stop recording, go to sheet 2 and run...

I know there are alot of ""And what is with all of the . = False stuff? You don't use periods to separate arguments, you use commas (or semi-colons if in certain regions)."" It seems to be taking my macro and creating invalid VBA code. I went to the same macro in Excel 2003 and copied and...

I created a macro in 2007. Tried to run it and I get some errors messages. Here is a few lines of my code: Range("A3").Start . = "=NOW()" Range("A3").Start .Borders = "[$-409]mmmm d, yyyy;@" Range("A1").Start . = "ABC COMPANY" Range("A2").Start . = "Quarterly...

Is there a way when entering data that you can pre-populate fields with the data from the previous record? such as date, same type of load etc. I know you can use Ctrl+' but I want to try and save some key strokes.

I am working on an invoice. Once I run the invoice, I want to update the table with the report date. You see, this company charges for storage of steel on their yard. From the date in (log it into the computer), I need to add 31 days (created a new field). He gives them the first month free...

THANK YOU! Worked great! I appreciate your help Deborah

I need some help, I can't get the code to work. name of main form - view records subform - view records subform what do I type in for the dataentry part?

I have a form where I have the user to select a grade of steel...a subform to display all the steel associated with that grade (combo box). My problem is that when I open it, I see records in my subform. How can I get it to open up with no records showing? Thanks! Deborah

The currentuser worked great. Can you do this for a security group? I have some VPs who will need to see all tickets and then I have users who only need to see their tickets. The currentuser for individuals worked great.

I have a database that I have secured by using Access 2003 user security. I need for the database to allow the user to login and once they have logged, to open a form and filter out only their open "tickets" - records. How can I do this? Thanks in advance.

I need some help. I created a database to capture information from an employee survey. Most of the answers required a check if they agree or no check if they do not agree. There was one "memo" field inwhich we allow the employee to VENT. I have provided the team with all sorts of reports with...

I have a database with a pre-surgery field and a post-surgery field. The use must enter the current procedure in the pre-field and then the actual surgery in the post field. I need to check to see if the fields match verbatim. The field is a memo field. The users know how to copy and paste from...

I am trying to figure out this process of normalization and how to get all the tables to work together. I want to use an autonumber to keep track of entry for the participant (demographic information). I am not sure how to link it to the other tables. I will be using autonumbers for them as well...

survey design - please help I posted a thread about check boxes and really did not get any advice that I wanted to hear. It was all good advice and it got my mind thinking about the design of my survey. I have a survey that has 3 sections that I want to extract and analyze data from the...

Option Box - Need all that apply I have a survey that I am creating a database to capture the results. On my survey is a option box that ask "How do you hear about the program" - Check all that apply. I created an option box however it only allows one bullet. How can I get this to work on my...

I have a database that is used to register students for class. As instructors, we can print rosters, certificates, waiting list, and other reports. Some of our classes have restrictions attached to them - basic excel must be completed before Inter excel. This program will also allow us to pull...

I did all that you stated and it still did not work correctly. I had to go in and generate an ON print event and use the following: If done = "completed" Then Me.NextRecord = True If done = "completed" Then Me.MoveLayout = False If done = "completed" Then Me.PrintSection = False It worked like...

Yes. On the report where the label is located, you want to activate the On format event and use the DisplayWhen function for screen only for that control name. Hope this helps. Deborah

I don't think you can use a subform unless there is a primary key defined not as a auto number. The primary keys have to match perfectly for the sub form to do it's job. Subforms can be tricky and I have learned from experience about matching the keys so the data is stored correctly. Good...