Recent content by mlh407

store in the code I want to hardcode it in the source code

Hi everyone, I have worked for 5 years with php+mysql+perl+apache on linux. I am working in vb2005 to get a crystal report to view. I have turned up debugging on my mysql server. Everytime I try to connect over odbc from vb, it tells me access deined. (Yes, I works from other remote hosts) If...

Hi everyone, I have an external program I need to run and get the output from it. (It queries a local device and returns a number). I need to take the output and put that into a field in access. Can this be done? Thanks for the help, Michael

Hi all, is there a way in access to get the day number of the year. so 1-1-05 would be day #1 and 12-31-05 = 365 Is there a way to do this? Michael

Hi Everyone, Is there a way for me, using access, to press a button and download an image from a website. Then display that image inside an access form? Thanks, Michael

Hi all, I need to know how to calculate the week number. There are 52 weeks in a year. Given any date, I want to know what week number it is. Does anyone know how to do this in access? Mike

Hi access gods, I need to know if there is a camera interface to access. So that I can grab a picture and store it in access(or the file name in access). I would I need a button in access, that takes a picture and either saves it to a file, or saves it in an access db (as a blob??) Does...

I am not sure if this should be in reports or under vba. I would like to take a sql query, (Select * from table_name where a=1). It might return 5-10 rows. I would like to have a script, that opens up a report, filters by a query, prints the report, closes the report, and takes you back...

Does anyone know how to get input from a com port and parse it into access?

Hi all, I am using access as a FE for a mysql BE. I have the odbc mysql driver installed on the workstations. My issue is that I don't want the users to be able to use the driver in say excel. I have the password saved in the odbc setup. So any application can use it. If I don't save the...

I want to create a linked table with the odbc connection information embedded. I know the driver (in this case, mysql) will have to be on the users computer, but they won't have to setup the acutally odbc connection. Is there anyway to do this in access here is the vb code...

How do I setup so that a user can click a button and view (in preview mode) a CR report?

Try using Crytal Reports. Via it you can export to PDF

I have created a crytal report, is there any way to link it (in preview mode) in access? So that users don't have to naviagte to the cr file and open it by hand, can I have the cr report come up in preview mode with no other options (like editing)

That works for me, but the issue is it just displays the report, I want to open the report as above, (that much I have done) then print the report, then close the report window so they are back on the form. It can print to the default printer.