Recent content by bhamilton42

Hello, first off, did you know you can concatenate strings using & _ ? I think that it better programming wise than extending the variable like you do.. your SQL lines SQL = "SELECT *" SQL = SQL + " FROM Group_" & cmbGroups & "_ATB_Daily_Grouped" SQL = SQL + " LEFT JOIN...

Beat me to it XD

aha! got it. you want the "quit" action in the macro. that quits access not just the database. Try that out. when i did it just now i used the "exit" argument for the quit action and it worked, especially because the close action prompts to save, but theres also a prompt and save all argument...

I dont have an answer yet, but a cause. The closedatabase closes the database, but not the program. Access itself is seperate from the database, so closing the database does not close access. I'm looking still for a solution but i thought id post the cause so that you can look also and maybe...

this was almost a year ago, so i'm sure you're done with it, but if not id be happy to take a look :)

You mentioned the merits of these prefixes, Here's an opinion from a student in programming.. I recently got a summer student job. I got plopped into an office of busy programmers with little time for explaining previous code (behind the scenes functionality) to me. My first job was to take a...

Ohhh I got it. Even better :D thanks much!

Hey thanks guys :) good to know :) @galaxiom you're very correcy about runSQL and infact I was using open Recordset lol. I was just really tired when I wrote the question.. taking time to do that was my idea of taking a break from code writting. As for the rest I think I will go with a saved...

I'm actually unable to discuss what is in the tables unfortunately. thanks for the reply though :) I was just wondering what people thought would run better and look better. I think I'll go with a string variable and use the RunSQL. If I dont have to save an object in there (query) then all...

Hello all I was just curious, what's the general opinion on coding standards/efficiency when it comes to executing an SQL query from VBA? Basically I have a subform datasheet, and the record source is going to be set as the result of a recordset populated from an SQL query. The user enters...

I unfortunately wold not be able to do that. My employer would not aprove. I assume then that there is no simple command to just say my_subform.form.defaultView = 1? it seemed so simple, but then it kept on insisting I do it in design view. *sigh* what a fickle creature is access. I shall have...

Other bob, I did create a seperate form and then dragged it over to be a subform on my main form. I also DID put the default view to continous on that SUBFORM. (the main form is in form view, the sub form is in continous form) However, even with the subforms default view set in properties to...

Bob, I did set the default view in properties to "continous form. If I open the main form in design view, then put focus into the detail area of the subform, then go to form view, then click the button to make the subform visible it displays properly. but obviously I can't have my users doing...

Hello I have toiled with this for the better part of 2 hours now and I need some help! I have a form that I'm making for a user. I want it to be a continous form. There are 8 records in particular that my user should see thus, a continous form as aposed to a single form. The form in question...

Thank you much for the reply, I just figured it out in the last hour. after you tab through a sub form, i think if you tab back in from the main form, it goes to where you left off. I used the "requery" method to reset the subform which fixed the tabbing. for the 2 continuous form subforms, i...