Search results

I am using access 2007. I have a table number 1 with fields. The one field is a combo box to table number 2. Now table number 2 has a field for OLE objects. If I view table number 1 in datasheet view, it shows OLE object (that is what will show on report obviously) So, I am trying to get...

Hi I'm using Access 2007. I am needing to duplicate a field (It is necessary) I use the following code. Private Sub Confirm_Course_Number_KeyPress(KeyAscii As Integer) Me.Confirm_Course_Number = YearMonth End Sub It works exactly the way I want, however the date is showing long. What code do I...

Hi again I'm using Access 2007. I've created a table with two fields. "Novice and Recertification" as in combo box. I put it on the form. Now the idea is when a user clicks Recertification, it shows up on the report. When the user clicks on Novice, it should be empty on report (Reason why I...

Hi. I am using access 2007. I click on a table for example. I then click blank report to make a report. I then insert a text box and then go to control source to select a field from that table. The field doesn't show up when i click view report? Thanks in advance. Jeff

Can anyone tell me what is the Checklist to follow when troubleshooting this? I have a combo box called "Rated Capacity" for machinery which lists the capacity weight of the machine. We've been getting clients complaining that they don't like to see 0 kg on their certificates. So I went to...

This might be tricky, but if anyone can tell me what to do, it'll be great. I am using Access 2007. There are two reports I generate. The one report makes use of normal paper. The other report makes use of the bypass tray which is the cardboard tray of the printer. Now when I have generated...

Just wanted to introduce myself. I'm Jeff and I wanted to thank PBaldy at the same time for his quick help.:)

Hi. I hope someone can help me here, I really searched and just can't find an answer to this. I am using Access 2007 and I created a module and put this code in: (This is to hide everything on top) Private Sub Lockdown() DoCmd.ShowToolbar "Ribbon", actoolbarno DoCmd.ShowToolbar "Menu Bar"...