Search results

thanks pat. that was a good explanation. I converted it to that format because I wasn't sure if the op was using a general date or a date time field. A date time field will fail sometimes if the hour or minutes are off comparatively. Your explanation was great though. on a side note I used to...

My bad and no worries. This is all kinda new to me as far as posting on here, but I use this site all the time for reference. It kept saying I should post and try to help so I am giving it a college try, but I have to say trying to write code on here is certainly a new skill to me.

So this should be your final product on it. I should have been more clear before on this one. Private Sub cmb_export_excel_bydatesrange_plot_Click() Dim filename1 As String If DCount("*", "qry_01") <> 0 Then if datevalue(me.txtday1) = datevalue(me.txtplot) then filename1 =...

I copied and pasted what you had earlier. To remove those just use if me.txtday1 = me.txtplot then filename1 = CurrentProject.Path & "\" & Replace(Me.txtday1, "/", "_") & "_qry_01.xlsx". else filename1 = CurrentProject.Path & "\" & Replace(Me.txtday1, "/", "_") & Replace(Me.txtplot, "/", "_" &...

For the first part I would use something like if me.txtday1 = me.txtplot then filename1 = CurrentProject.Path & "\" & Replace(Me.txtday1, "/", "_") & "_"_"_qry_01.xlsx". else filename1 = CurrentProject.Path & "\" & Replace(Me.txtday1, "/", "_") & Replace(Me.txtplot, "/", "_" & "_") &...

Why not do something along these lines in VBA to run this? Private Sub sbmt_Click() Dim strSQL As String Dim strtTime As Date Dim endTime As Date If Forms!JobReport.Form.Controls("Shift") = "Day" Then strtTime = Forms!JobReport.Form.Controls("dte") & " 7:00 AM" endTime =...

So you think I would be better off going with the below type of statement? If Not .bof and .eof then I'd rather do the better practice since I kind of learn as I go and I have never really had much input on my codes (unless something was not working)

Great ideas guys, thank you all! This is a very interesting discussion to me. CJ - I am definitely going to split them out. You guys have sold me on that. Thanks for the info. Frothingslosh - I have experience with a couple of batch files, but some of the users here do not have...

CJ - I appreciate the thought. I am mostly self taught in this, so if issues do not come up, I do not learn about certain things. The programming I was actually taught was mostly web based and I do not recall too much about corruption. I heard a little about Access should be on every user's c...

I do have multiple users using the same front end. They all link to one .accdb on a server. We are constantly changing and updating things. My responsibilities are not primarily the database and I would not have time to update 50 users front ends on a normal basis. I could write it into a batch...

Just to weigh in since the conversation has gone this way, we have 8 front end databases (before the amount of users I believe was more limited in 2003 so they were broken up by department). These were all converted from 2003 to 2010. The main problems we have had were the calendar objects did...

That's great to know. Thank you. I've certainly wasted time with that in other procedures.

If they ran the code prior would it possibly be populated from the last go around? Like running it twice in one session?

Agreed.. They named these very poorly. I just never had time to delve in to changing all of this stuff honestly.

I'll give those a shot, thank you. I know the records were populated throughout in the instances it was throwing an error. The recordset clone is a very good thought though.

Thanks for having me.

I hope this is the right place to put this... Please let me know since I have never really done the forum thing before. This is to go through multiple subforms and calculate a total estimated and actual for each material listed along with carryover for the pricing. It worked great until we...

Hello everyone, I do some programming fro the company I work for in Access with a SQL backend and quite a few excel documents. I mostly do fixes and additions to the database at this point, so I am definitely not a full time programmer. I am a long time lurker on this site since they have me...