Search results

i will be moving to the outlook automation as i am using it in a different database just dont have time to change all my code over (theres a few reports i need to use it on)... just wondering if anyone had a similar issue to mine and if they have resolved it really to buy me more time

its really weird, i've realised it must have something to do with the emails they being addressed to. this only started happening after upgrading to a new pc. i never had this issue on the previous pc i was using it with.... it is really weird......

Hi guys, been a while. i have a button which sends a report by email using the DoCmd.SendObject acSendReport function. it has worked for a few years and never had an issue. basically when i press the button it loads my pdf into a new mail message in outlook, once i'm happy with it i press send...

hey guys, after some information, currently i am running a db in 2 parts, both in access, a backend and a front end.. obviously backend holds all the data, and the tables are linked into the front end. i been looking at having the backed converted to an SQL server and use a service like Google...

yeh thanks guys! forgot to reply back here!!

YES!! this is what i was looking for! ty soo much!!

hey guys, its been a while since i have posted on here, i have a form with lots of buttons and all working fine. the major function of this form is the buttons on the form all basically use DoCmd.SendObject to create reports from the database and email to clients, and it all works great! i...

ahslee dawg!! you my friend are a legend! all you guys on this forum are soo helpful, i am learning soo much! that is exactly what i want to do! its not a publicly accessible database, and the form that it runs thru only i use it! many thanks again, i look forward to my next problem :)

hey guys, soo i want to create a macro which clicks a button in my form. i tried doing Create sub macro and giving it the name ^6 (which is CTRL+6) and add the action RunCode and put the function name as btnCharge60Day_Click() (which is the were the code i want to run) but it doesnt work ...

just like pbaldy said, you need to take the names you want from a form. i have recently done this myself (and just like you im still learning) Dim TheFileDir Dim Warehouse Dim PONum Dim TheFileName As String TheFileDir = "Z:\Documents\Invoices\" Warehouse = Me.txtTheWarehouse & " " PONum...

Jack, thank you soo much for all your help.... i would not have been able to fix the issue. there were a few errors, but the data type conversion error was not in TimeCharge or PhotocopyCharge, it was in Code where i was trying to put a string into a Number so i made a slight modification and...

TimeCharge is a Number - the code i use to set variable as Dim TimeCharge As Integer and PhotocopyCharge is Currency. i've removed the quote marks from TimeCharge and PhotocopyCharge as well as just tried it alternate ways... how should i be handling currency and Integer data types ? when i...

so it seems the putting brackets around horrible name worked, however.. there is still some conversion issue... i get this error now http://imgur.com/a/GghTP

i changed to this from your advice, but still giving me syntax errors TheChargeDate = Format(Now(), "MM/dd/yyyy") Dim strSQL As String strSQL = "INSERT INTO [Charge Data](Date, Code, Number, Prospect, Detail, Time, Photocopy) VALUES (#" & TheChargeDate & "#, '" & ClientToCharge & "', '" &...

further to my question above, i've implemented the the code thanks to AuntiJack, Private Sub btnCharge60Day_Click() Dim TenementNumber As String Dim TenementProspect As String Dim ClientToCharge Dim TheChargeDate As Date Dim ChargeDescription As String Dim TimeCharge As Long Dim...

thanks soo much! that exactly what i was after.. thank you for the warnings. the code i done above is just an example. i will not be using names in the final product! bloody legend :)

thanks for your reply but i dont quite understand what you are trying to get me to do. i have an existing query for the form, i want to have a button on this form which when i click, takes the information i need it to take and enter it into a separate table. the example below is a test i been...

Hi there, i have a form with some data and what i want to do is create a button which takes some of that data and enters that information into another table within the database. to me the concept sounds easy i just do not know where to start! :) hope someone can help!

hi guys, its been a while since i've posted, i'm back into advancing my work's database. so right now i have a report which issues approx 30 pages, each page is an invoice for a client. i have created a button which converts the report to a pdf. MonthNum = Me.Select_Month NameOfMonth =...

Thank you!! spot on!!! i knew it would be easy! :P