Search results

It is a me problem. When I click on the direct link, I get the message from my work "Net Nanny" that the site is blocked. I will try them from home.

Sounds Like the "Net Nanny" here at work might be the issue. I will have to try it from home. Thanks

Thank you for the link. It is printing out as I type this.

Thank you. I noticed that the link refers to VBA and Excel. Am I correct in believing that VBA for Access and VBA for Excel are very similar?

Thank you. I will look into that book. As for the video I get this message when I try to play it: The webpage at https://www.youtube . com/embed/kogGwRIHH6o?wmode=opaque&start=0 might be temporarily down or it may have moved permanently to a new web address. (Added extra spaces to prevent the...

True but it is a very slow method.

maybe you misunderstand my level of knowledge. I see posts where some say they want to do X. I think 'Great, I also want to do that." I go to the thread and when they either post the code they started with, or someone posts a solution, I have no clue what I am looking at. It might as well be in...

You input on VBA vs SQL is noted. Thanks. Even being self taught, you had to start someplace. How did you go about learning VBA? Where did you start? Did you know other programing first?

And where or how do you recommend I learn each thing as i need to do it? Asking this site every time I want to do something is not only time consuming for me and those that answer, it also doesn't really teach what is being done or why. Usually questions are answered with code to do whatever...

i am looking for resources on how to learn to write code for Access. While looking on the web it appears that I can either get books on Access or on SQL. Should I be learning VBA or SQL? I do not anticipate using it much beyond this current project. I already have a functioning database but...

Except I found another problem. I wrote code and it tried to work but failed because I am using a parameter Query and apparently DCount can not be used for a parameter query. So I am starting to understand what need to do. I just am having a hard time figuring it out with only Access help...

OK. Then why does the Macro allow me to insert the DCount command? Is that just Access being Access? It seems strange to me that they would allow a command to be listed that can not run. I would need to write a Module (?) with the code you listed, (with pertinent information filled in) and...

Lets see if I am reading this syntax correctly. Count all records found in the results of the named query, regardless of which field contains data. (The "*" wildcard.) If that count is greater than 0 then open the form. If that count is not greater than 0, then follow whatever the "Else"...

NOOB question here. I have an equipment testing log database that uses a Short Text field for Serial Number (Some serial numbers have characters in them). I have a query that uses the Criteria of [Enter Serial Number] for the Serial Number field. If the Serial number exists it display a form...

Show me a manual for Acess365 and I will read it. And how did you originally find out about it? Let me guess, someone told you about it.

Been Trying to post all day that theDBguy's suggestion worked great. Finally it let me post.

I have a simple form I created using the form wizard that I use to enter part numbers. I added come control buttons to the form to close the form, see last record etc. I also added a Enter new part number button. When I click the button, the form clears and goes into entry mode as expected...

Thank you. The easy way almost worked. When typed as you wrote it I got a circular reference error. I changed it to Begin Date:[Start Date] and Last Date: [End Date] and it worked just fine. This will allow me to put dates on the reports for now. I like your suggestion of the form for date...

I am looking for where to learn how to do this, not have some one do it for me. Note: Everything I have done so far has been through the built in Access wizards etc. I have written no code. I have a number of reports that use dates that are put in to the query by Message Box. I have attached a...

THANKS, I did not think I had any code to compile as I had not written anything. When I ran Debug, it found some old embedded code from an on open event where I was trying to handle the no records returned situation. There was no outward indication that the code was still there. Once I deleted...