Search results

I think we are going in the wrong direction, but I could be wrong. I have a report based on a query. The query reads the value of 'PictureProof' as being "Yes". So when I run my report from this query, the PictureProof for two of the three lines is "YES". Based on that, I want the...

When I right click on the picture, the "Build" is greyed out, I can only "Build Event". I don't have a revised Load()Sub, it hasn't really changed yet.

I don't think I explained it right. I have a table 'Order Form' of which I have forms made from. The form I am using to gather the info for this is "Apparel Order Form". I have a Report named "Apparel Docket with Header", which gathers info from a query based on a different Table "Jobs List"...

Actually it is, but while I am testing it, I am using it in the "Mother" form. not as a sub form. Does that make sense? Let me try to explain it differently. I have a form called "Apparel Docket" and it lists the different items. I put apparel Docket as a subform on a report called "Apparel...

PR2 I originally put a YES/NO box in there, but I couldn't get it to work, so I changed it to a list box with two options, "YES" or "No" so I could look for text. When I had the check box in place I tried the code that you recommended, but that didn't work either. AceBK

I am working on an order form for production. The Docket allows you to add multiple lines for the order and perhaps the Sales rep would like some pictures taken of some of the items but not all of them. I put in a list box with "Yes" or "No" on the form. On the report I have put a picture of...

I have found the macro to send reports to an email address, the big question that I have not been able to find an answer to is, can I set a "Reply-to" function through an Access Macro? If not, how do I convert just the one macro to VB code and what is the code for the "Reply-To" function. Thanks,

So I tried to type in your SQL code but when I put it to 'update' query it changed the SQL I put in and added an 'update' line. Also, it asked for a destination field? Is that the "id" field?

I have a database that is tracking donations for my organization. I have some members who donate the same amount every month. Is there away to copy the records and paste them with the current date in the "Date Paid" field, and do this "Update" once a month? As opposed to typing in 200 records...

That sounds promising, how do you do that exactly? I am not that familiar with VB

Good day, So I am continuing to build my database and have learned so much already. I am trying to implement a username and password system on my DB. What I have done so far is created a table with username, password, permission level and datestamp. So when the db is opened, the form pops up...

Thank you both for your responses. You confirmed what I thought I had to do.

Hello, I have been developing a database for a little while now which allows me to make work orders for certain items. I have a table that I can fill in on a form to make the work order. I will select a part number for an item and by using a query I pull in the price for this particular item...

Bob, you are very good. I was missing the s in 'Jobs list 2'. After that fix, it worked. Thank you for your help

Bob, Thank you so much for helping me with this. So I added the new function and changed the control source of my fields, however, I get the same error message as before. When I hit the 'debug' button, this is the line that gets highlighted in yellow: If...

Option Compare Database Function IsOpen(strFormName As String) As Boolean If CurrentProject.AllForms(strFormName).IsLoaded Then IsOpen = True Else IsOpen = False End If End Function That is my Module1 code. In my text boxes I have Textbox 1 =IIf(IsOpen("Jobs...

Bob, Thank you for your response. I did what you suggested and I came up with an error message. I have attached a screen shot of the message. Do I need to change "strformname" to something, or does it stay as is. Ace

Hello, I have been working with Access for a little while now, but by no stretch would I consider myself "Experienced". I am running Access 2010 and have run stuck on an issue. Please help. I am building a form that is finding the "Docket Numbers" from three different forms. In order to...

I don't think DCount is quite what I am after. I read your link and I understand the DCount to be a count of records in a series of records. What I am after is the count of the list box to show up on the report for each record. I suppose what might work, if possible, is to count the values of...

John, I followed your link and I got it to work. My first problem was I was using a combo box and not a list box so as soon as I changed that, it worked. However, I am having a hard time getting this count value onto my report. For each record I need a count and I am not sure how to get this...