Search results

okay its not the prettiest thing, but its has the information I need.

Hi, I know I have several problems I am working on at once, but each time a new one comes up it is more pressing than the previous one. Right now I am using the following code in a database...

Well, I have made a report with 7 sub-reports and it still asks for the date input 7 times and in the 2 different forms. Keep in mind each of these reports is based on a different query and each requires a date input. They only have a date in common but the dates are not linked in anyway. Is...

Ah, understood. I will definitely keep the tips in mind.

Ah ok, thank you for the tip. Just out of curiosity, why minimal height? What happens?

I have tried to go back again today and reference the information you provided in the attached link, however my company has restricted access to the vbforums site. I do not have microsoft products at home, so I am unable to really do much from there. So right now, I am at a complete stand...

I have honestly never done that or had a need to do that before. I will give it a try tomorrow while I am at work and see how it goes. Thank you for the suggestion.

I have the process I use for combining them with no issue. I am just lost on how to get them to pull the information to the reports using a single input.

Hi, I am curious if what I am trying/wanting to do is even possible. The usage of the following s for pulling up historical records. I have 7 reports and the only thing they have in common is the date of each report. 5 of the reports are date specific, and 2 of the reports are for the...

Thank you but this it appears the link you provided is referring to using shell commands. To my knowledge, which is limited these commands won't work in VBA, but I might be wrong. Please let me know if I am wrong. But thank you for the reply either way.

Hi, been awhile since I was on here. Right now there I am on the last part of my current project and I have no idea how to solve my problem. I have a specific Windows folder that I need to close when a button is clicked on a form. I have 0 code on how to accomplish this. Basically, a blank...

I will keep playing around with the ideas that have been presented here, but I took a look at my database and currently it is not very large just under 8MB, so not really that large yet. I am mostly looking at this for when the DB becomes excessively large and needs to be cleaned up. Who knows...

Okay, after looking into this method of copyfolder and using that, it copies all the folders I need over, however it is renaming them to something I am not wanting. I am using the following: Private Sub Command35_Click() Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFolder...

I have been scouring the web and forums and am unable to find anything to my issue. I am in need of a way to push a button on a form and have it copy all files and folders in one location and then essentially paste (generic MS term I know) them to another location. The only way I know how to do...

Well the only person that would be running this delete process would be me. But it would just simplify things considering I have several tables I have to run through.

I have been going around and around looking at this post for days. Actually all of the posts. a lot of focus seems to be on the length of time. The length of time I was using as an example was to allow for context was all. I have already checked for our time limits, I am just not authorized to...

Okay, I am not sure if this belongs in the table section, but it is dealing with the data of tables. I am looking for a way to click a button and have information from a table deleted if it has been in the DB for more than 3 years (not sure the time frame yet, but lets just go with that for...

okay, i think i figured this out after playing around with it. I am using the WhereCondition to apply the search criteria and allow it to open the report with only my selected search criteria. Thank you everyone that answered my plea for help.

I like what you did with this. I am looking at the code that you put in. I am trying to modify it so when you click search it will actually open the report to show the results. But I am finding out that it is not as simple as changing the openform to the openreport command. I really like when...

I understand what you have pointed out to me, but I am still stuck trying to resolve it.