Search results

Hi all. I am using vba to upload files to an ftp server. After some tweaking and trail and error I have it working correctly except for one part. I am not sure how to make it find if the directory exist or not. Open "G:\script.ftp" For Output As #1 Print #1...

Anyone able to help? Thanks in advance...

Hi all. Still being a VBA newbie, I can fudge myself through most things but a little stuck on this one. I am using code I found that uses outlook to send emails. I can get it to attach one file but I need it to be able to attach several that the user selects. I think I need an array to go...

I am trying to display a message box with variables from a record that is found using a query in vba. I can get the correct number of msg boxes to display but it only shows the value from the first record. Can someone tell me what I am doing wrong? Please and thank you Dim strSQL As String Dim...

New to web forms and having an issue with a combobox. I finally got it so I could select a record to display in the form but since I have 5777 records and the combobox will only show so many I need to find a way to dispaly them all. The one I am making this for does not want to type in a company...

Again, thank you very much! Yes, everything passed the web compatibility, and I have everything on the host. I did start to create a web form last night. The only problem I am having right now is trying to create a combo box to select what records show on the form. Thank you and you do a great...

Thanks for the answer. No I haven't. I am just learning Sharepoint. I was under the impression that it could convert a regular form to a web form. I tried finding some info on web forms but found very little. I'm not even finding how to create one. Thanks again, -Matt

Sorry, I didn't explain very well. It is disabled (greyed out) and just says none in it. All of my forms and the table check out fine for web compatiblity and I have uploaded to share point with out issues. Thanks for your help, -Matt

Playing around with Sharepoint and Access. Does anyone know why I can not change the option for the web display form in the options of the current database? Thanks, -Matt

Thanks, I posted over there. I hope someone can help me out. I know it has to be something simple but I just can't figure it out. It's driving me crazy. Thanks again, Matt

Not sure if I am posting this in the right place, sorry if it's not. I am stuck. Not real familiar with mysql or php but can fiddle my way around. I am trying to set up a script that will get email addresses from the database and insert it to the script and email the addresses it gets. I have...

Hi all, I am trying to figure out how to insert a number based a few things. I'll get right down to it. This is what I have. Column A Column B Column C Description Amount Date entered I need to find the latest date where column A = "house" then I need to see if it is greater...

Nothing bad is on my mind. ;) I actually work at a casino and during break one day it came up during a conversation that we did not have a way to check IDs against a master list of people who were trespassed without going through the list manually. So as a project to do at home I thought I might...

Thanks. Unfortunatly it is not a keyboard wedge and can not be set to emulate one. It is built from spare parts at work. I know it is sending data through the serial port by using a com port tester program, but I don't know how to get the data from the serial port into access. Thanks, Matthew

Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get...

I also need to add a space 2 places after the decimal when I run a report. I tried the above string but I'm not sure how to do it. Could someone help explain how to use this a little more. Thanks.

No, I hadn't Rabbie, I didn't even know it was there. Now I guess my next question would be is what code do I use to print the pdf? Thanks, Matthew

Yes, exactly.

Hi all. Using Access 2003 I am trying to figure out how to print and collate a report and an existing pdf file that is opened based on a field in the record. I figure that it probably has to do with looping through the records but I am not very good at that. So I have a form with a sub form...

Thanks. I thought that if I put it in the enter event of the text box that it would sit and wait until the enter key was hit. Didn't think that it would run when I opened the form. I guess I will put it back behind the button. Thanks again, Matthew