Search results

Can anyone recommend a free site where I can download images/icons that will accompany my database. I have a Home form/screen that I want to place the icons/images and make buttons out of them to open the accompanying form. Although I will still have text descriptions I would like the graphic...

OK, I figured it out. What I did was. When I added the image, I changed the name of the image in the property sheet and changed its visible property to no. But what I actually did was I inadvertently selected the detail/background section before those updates, and changed the name and...

I just finished touching up my form. Everything was working perfectly the way I was planning. I wanted to add one more aesthetic appearance by adding an image and only displaying it when the status of the form is marked approved. I added it and don’t think I accidentally changed some kind of...

Thanks I think this is what I would need, but i don't quite understand it. Would you be able to correct my errors check if my descriptions are correct and fill in any blanks below: Code on control to open Customer detais form: DoCmd.OpenForm "Customer Details", , , , , ...

Is there any way to determine the value type of an openargs value being passed, and then assign the value to the appropriate field depending on its value? Example: The onOpen even of my customer details from is now set to assign the openargs value (if any) to the Account Number field. What...

Thanks again that did it. Got scared for a second there!

Thanks for all your help pbaldy. I'm going a little off topic here and don’t know if I should just start a new thread, but you helped me a lot with my last problem, and maybe you can help with this new one. I did the changes you suggested and it works great!!! BUT, now the strangest thing is...

WOW, I'm actually embarrassed to actually figure out how simple that turned out to be. Thank You! I did figure out a different, way more complicated, way to accomplish it, but I'm almost positive that the way I did it is very poor design. If you want a good laugh let me know, and I'll post...

that is exactly what I am trying to do!!! I've posted several posts about how i'm trying to do that and haven't gotten much success. I've gotten a lot of tips and tricks, but nothing that really helps im my situation. It would be great if you can supply me with those instructions on how to do...

Thanks, the Dlookup function now works. Now lets just see if my theory of how to use it will work....

I have a form where I select or type an account number from a dropdown combo list field and it navigates to that record. I'm trying to add another field (the address field) to do the same. I've come up short on all other means of trying to accomplish this, so I came up with trying to lookup the...

OK, so I kind of remembered how I configured the account number field to "autofill" other data on my field. When I created the form, I added the account number field as a combo box form control. From there was a wizard to with one option to "Find a record on my form based on the value I select...

I was working on a database design several months ago and learned very much quickly at that time. For whatever reason back then I just stopped working on it when I was so close to finishing it. Today I started working on it again, but unfortunately I forgot mostly everything I learned back...

Ah thanks works great!!! I never really learned much about vba code, and what I do know is stuff I just taught myself. I can read most of it, but when it comes time to write it myself, I cant get the syntax correct. i would of never of figured out this one on my own. Thanks again.

I have current code that first updates a field named Exported in a table to the current time (using the Now() function), then it opens a report based on that table with criteria of Now() for that same Exported field. My current code is: DoCmd.RunSQL "UPDATE [Orders] SET [Orders].[Exported] =...

Thanks for the answer. So for a more real life example, maybe you can solve my problem. I have a query (Charge Summary). I have 1 form and 2 reports based on that one query. Form 1 is just a summary of all records, hence needs no criteria. Report 1 shows records where the status ID equals 4...

If I have an access query lets say somthing simple like customers which has criteria like Status = 4 (BTW. this would be an Access created query not something created in VBA or other places). Now, I want to base a report on that query. To open the report I have a button on an unrelated form...

ah... good thought. I'd never of thought to use a text box instead. I 've not worked much with conditional formatting, but I agree and don't think you can format a label.

I have a form with continuous forms view (actualy a subform of a different form) with only 3 fields: Charge type, Amount and Date. What I need to do is change the caption of the date label to something different depending on the value of the charge type field. I figured that part out pretty...

Thanks, that seemed to work so far. I haven't tested thoroughly though. This brings up another problem though. Like stated before, I have code that exports the query to excel. The code for that is: DoCmd.OutputTo acOutputQuery, "Exported charges", "Excel97-Excel2003Workbook(*.xls)", ""...