dhookom, your suggestion works great. Thank you very much.
Andrzejek, your suggestion sort of works. When I execute it I get a dialog box that says, Error: Invalid Operation. Before I can click the OK button it drops the data in the field. Thank you for your suggestion.
Thanks for the reply dhookom,
The primary key is the ID, set to autonumber. I'm not back to work until Tuesday. I'll look into your tips then and let you know.
Thanks again,
renigar
I have a database that keeps track of water utility repair digs. When the repair dig is complete the crew lead fills out a dig card. I'm scanning the cards (because the cards have hand drawn details of the repair) to pdf. The pdf will be kept in a separate directory and opened into the default...
Regarding thread 702-1753559 hyperlink/browse for file, Link
The link above is exactly what I am trying to do. I know a bit about Excel VBA but very little about Access (365) VBA. I'm a little confused on how to link the code to the text box where the hyperlink would be entered. I assumed that...
Thanks dhookom,
I've been googling the function and the pages tell you the syntax but don't tell you where you use it. In a query, in the report? Could you please provide a little detail or direction.
We have a simple employee database, 1 table, names, addresses. work cell phone number, etc. A new cell phone list is distributed whenever there is a change. Some employees are widely known by a nickname which we have a field for. When printing the report I would like to replace the first name...
Sorry Skip,
I thought I had removed it previously. It should work now. Here are a couple of shots you can look at and not open file.
Hours sheet
Summary sheet
I have a file that is used to track employee time off without preapproval to see trends. It is attached below. It is set up to track for a calendar year. There are two main sheets in the workbook, Hours, where the unapproved time off is input and Summary where you see how many hours were...
Andrzejek,
I added a two second delay and that did the trick. I still don't understand why. It always works if I print from my computer. All the computers in my office are on the same network. It may be that some users are on thin clients (I hate those). Those things are always slower. At least...
I have a simple Excel macro that prints out vehicle inspection sheets. This is a chore that is done monthly at work. The macro prints sheets based on what vehicles are in a list. The sheets are named for each vehicle number and the list the macro refers to are the vehicle numbers to be printed...
Andrzejek,
Wow, you have gone above and beyond. Didn't expect you to actually write it for me. It works great! And looking at the code it actually looks easy. I may have gotten there on my on after much trial and error but you have saved me some hours and given me a nice lesson at the same...
Thanks for pointing that out to me. There is always something I didn't consider. I also forgot to limit the number of characters to 9. I thought I had an easy answer. How wrong I am. Is there a way to do this in a formula that would fit in Data Validation? I don't know (understand) how to...
Thanks Andrzejek,
Right before I read this I decided to evaluate the first two characters separately. It works how I want with the following formula and comes in at 227 characters which will work for data validation...
I want to limit errors on item ID entry to this exact alpha numeric format: AANANANNN The entry will always be 9 characters.
Example ID: WD5A4V336
I searched through the posts and found a problem similar to mine but don't quite understand the formula used and the formula is to long for data...
Thanks Andy,
I'll make that change.
Combo,
Thanks for the tip. That would be a great improvement. Unfortunately in my organization we are using a mix of different versions of office. I have 2010 on my Desktop and I would have to check on what versions others who may use the workbook have.
Skip,
Thank you, but I still couldn't get your example to work. With some reading and changes I got this section of the code to work. I have posted below just the relevant section of code for anyone who is interested. Assume Option Explicit, everything dimmed and so on. With these changes the...
mintjulep
I don't know much about arrays other than being aware they can be used. I'll have to do some more reading now.
Skip
Thanks for the code. It throws an error on your Set rPen. Looks like the Cells reference is off. And the i is before the loop. Even though I can spot that I still don't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.