Recent content by JeffAccess

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

Does anyone know what I can do??

Haha! My pleasure!! Maybe you can check out this post I sent? http://www.access-programmers.co.uk/forums/showthread.php?t=252851

Great stuff! It works! Thanks:D

Sorry pr2-eugin. I'm still a newbie with this. So my form name is "Attendance Register Marketing" and the ControlName is "YearMonth". How do I put it in? It tells me Compile Error, Expected end of statement and it highlights Register??

Missinglinq.... Just a quick question? I was using the same control on the same form. How does one go about using a control from another form? Thanks again Jeff

Hi Missinglinq! That was perfect!!!! How do you all know these things? Thanks. Appreciate the help!:) Jeff

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 CazB! I get the idea of what you're saying. It didn't work though? On the form, the novice is blank, but the user needs to see it and click on it. It's only when the user previews the report that the novice mustn't be seen on the report. So if the user selects recert, then it must show on...

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 pr2-eugin! I found the issue, silly me. Now I'm starting to get the hang of the access. In the design view, in the properties view, I didn't select what the query I'm using to extract the fields from!! Jeff

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

Hi pr2-eugin! That was an interesting read. Well, I'm actually gonna avoid them a bit more in future...:eek: Besides, thanks for the great website, definitely saving the address to read up a bit more on it!!

Can't believe the lookup was giving me the hassle!!! Problem sorted when I removed it, now it works and it appears on the certificate exactly the way I need it to. Thanks a million:)

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