Recent content by Rand

  1. R

    More Free Programming Books ("Last one I Promise")

    We can never have enough resources for improving ourselves, so here is another great site for those that want to improve their skills in any language. https://riptutorial.com/ cheers :)
  2. R

    New Learning material

    Free programming books which look like somebody can use/ Not my domain but stumbled upon it,check it out free and seems pretty good for any language. there all in pdf formats and even as a season pro for vba and access there is some stuff i did not know. check it out and share. toronto canada is...
  3. R

    Please help easy for you

    in the second box = DLookup("[name]", "[your table]", "[id]=" & textbox1) or bind the form to the table or in the first text box use a procedure after update and use the dlookup in code oopz someone beat me to it:D
  4. R

    a quick image in email body by using a link

    heres a simple solution i needed to use basically i didnt want to send emails with an image as an attachment i wanted it in the body. also i wanted to use an image from the internet not on my hard drive. so this quick program allows this. you need outlook and also a reference to outlook 14.0 or...
  5. R

    Sample Database area submissions

    I realize the importance of security and such when someone is submitting a sample database etc but 3 to 4 months after it gets uploaded it gets approved. that's a long time .. I realize that people have not alot of time to monitor that area but i think that in respect to the people giving their...
  6. R

    Importing text files into access within date range

    what do the filenames actually look like in the directory ie: 10-19-2014.txt
  7. R

    This time goodbye is for good

    Wow, I have been reading Bob's posts all over the internet for solutions and fixes to access and vba related problems for several years. I and many others have learned so much from Bob larson that he should get an emmy award from microsoft. Good Luck BOB :)
  8. R

    Application will not Quit after running Docmd Outputto

    sounds to me the doevents is just letting access foreget about the excel being open till windows terminates it. you need to kill it ex: Dim objApp As Object Set objApp = CreateObject("Excel.Application") objApp.Visible = True objApp.displayalerts = False objApp.Workbooks.Open...
  9. R

    access 2010 Query dates

    Re: access 2010 Query dates [Solved] It worked! thank you I changed the day just to see if the records would change along with it. I will take your advice on the naming conventions now that i know it can be done. thank you again i have been messing around with this for a week now. your awesome CJ
  10. R

    access 2010 Query dates

    ok found the param thats giving me the issue: heres the statement strSQL = "SELECT hrs, bs, dte, emp FROM emphrs WHERE (((emp)= 'Andy') AND ((Weekday([dte],1))=1) AND ((Month([dte]))=Month(Now())));" its the name of the employee in single quotes which works but i have a field on the form that i...
  11. R

    access 2010 Query dates

    the dots are there cause its based on a query i guess. if i remove them it say 3265 item not found in this collection if i run these sql statements in the query designer i get no errors and correct data.
  12. R

    access 2010 Query dates

    CJ: basically i have a simple table of fields : wkday is the query name heres the sql for it: SELECT emphrs.*, emphrs.dte, emphrs.emp FROM emphrs WHERE (((emphrs.emp)=forms!CalendarAnnual!Text105.value) And ((Weekday([dte],1))=1) And ((Month([dte]))=Month(Now()))); emphrs is the table name...
  13. R

    access 2010 Query dates

    Nice it worked ! tnx a million i was stumped after trying different things, i figured i would need 4 queries to do it. but now im getting an error when reading the query in vba sql recordset. this statement works great in the query window but gives an error "3061 too few parameters -1" when Set...
  14. R

    access 2010 Query dates

    access 2010 Query dates [SOLVED] is their a way to have a query to only show data on every monday in current month. Month([datefield])=Month(Now()) And DateAdd("d",7,[datefield]) maybe someone can help me out. tnx
  15. R

    need Help with multiple sql criteria

    combo 86 is text and i keep getting an error see attached image the numbers are date serial numbers. it works if i dont use the combo86 clause the syntax is as follows: strSQL = "SELECT Qry_CalDataBS.dte,Qry_CalDataBS.bs " strSQL = strSQL & "FROM Qry_CalDataBS " strSQL = strSQL & "WHERE...
Top Bottom