Search results

Okay....I finally fixed this. It's kinda weird though and I'm gonna let everyone know how I fixed it in case someone else has this happen. First, when you go to the tools>customize, the toolbox toolbar does not appear in the window that lists the different toolbars. I don't know where it...

This just happened to me too. The toolbox icon shows up on the toolbar, but pressing it does not open the toolbox. How can I get the toolbox back? This happens in both form design view and report design. Any help?

Your problem may be that you only have a two column combo box and access starts numbering the columns at 0, not 1. The first column would be .column(0) and the second would be .column(1). Switch it from Me.textField.Value = Me.listBox.Column(1) & ", " & Me.listBox.Column(2) to...

One other thing to consider Mike. Eventually, you will run out of room. I'm not sure, but I think Access has a limit on the number of objects that can be in a database. Again, I'm not sure about that...but I thought I saw it somewhere. Also, each object takes up space and even if there is no...

That is true Rich. Never thought of it that way. Takes me about that long to add items, vendor or customer information to my dB also. I agree that the time savings are huge. Also Mike, another point about this that I think someone else brought up a while back. It's the issue of...

It's been said before and I'll say it again. If it works...it works. Doesn't matter how it get's done, as long as Mike is happy with it and it works for him then that is all that matters. :rolleyes: Mike, I think the article that Pat posted the link to is pretty much what I was trying to...

I agree that there are definitely preferences to ways to doing things. I have some differences between the way that I name variables during coding and that which is "standard". That's okay though. We're all gonna have some things that we prefer over things that others prefer. My problem was...

Mike, I understand your point of view...if it ain't broke, then why fix it. It works for you and that is the most important thing. However, you have to understand that the folks here are trying to help, not attack. Just because something works doesn't make it right. I have one big...

I believe your problem lies with the second to last line in this block. You have an "END" listed here. Should this be "End if"? If it should remain as END, then you are missing one End if statement related to the beginning if-then of this block of code. HTH

Try contacting the publisher. I had the same problem with a used Access book that I bought. I contacted the publisher and they sent me a copy of the CD within a week. You never know until you try.

Or, you can modify the open statement to: DoCmd.OpenForm YourFormName, , , , acFormAdd By adding the acFormAdd part, you will open the form in data entry mode and be able to add records.

Ok, I'll give it a whirl. stDocName = "frmAllOfficialAction_Patents" stLinkCriteria = "[PublicationNum]=" & "'" & Me![PublicationNum] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria The link criteria you are using has to have a valid value for it to open correctly, that is why an...

Search this site for Audit Trail or something to that effect. There have been alot of posts regarding something similiar to this.

They are not stored anywhere at the moment. I have a command button that when clicked generates the numbers. The result then populates a text box. I know that I could probably create a table and populate it with the random numbers than get generated and then do the query, but I was hoping...

Hey all, I'm trying to come up with a way to generate 4 random numbers and then add the three highest numbers together to get a result. I can generate the numbers, but am not sure how to add just the three highest numbers while ignoring the lowest value. Any ideas?

Try contacting the publisher to get a replacement copy of the CD.

I am assuming that the NewRecord function does not lie within the report's module, but within a different module. When you call a procedure from a module you must reference the modules name as well as the procedure name. Call modulename.procedurename(arguments) HTH

Whenever I get that error, it is usually because of a spelling mistake somewhere in the code, not with the command words and syntax but with the name of a table or query. Not sure if this is the case with you, but double-check all of the spelling first.

No problem. Glad I could help. FYI...When you're using those ActiveX controls, I've found that looking on Microsofts site for info on the controls in Visual Basic is helpful. That's were I learned about those events and stuff.

I'm not that familiar with that version of the control, but most ActiveX controls have more events than those that are listed on their property sheets. Those listed are usually just the custom events specific to that control. Try going into the code editor. Select that control from the top of...