Recent content by robertbwainwright

It did work Ranman. I needed to shut off "Convert All Picture data to bitmaps" in Options/current database

I'm trying to create a continuous form with a dynamic image on it in Access 2013. I have created a text field that contains the path for the image and drop it on the form, I drop an image control on the form as well, select my text field for my image path in the control source, but no picture...

actually I'm trying to change several things from line to line. I used this as an example so not to complicate things, hence I can not use conditional formatting..... Thanks for the replies.

I've created a report, and I am trying to change the background color to red based on the value of a textbox being 0 and it just is not working. I'm thinking I'm using the wrong event.... Here is my code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If RndQOH = 0...

Thanks for the video, but it still does not work. I followed each step exactly as the author did. I end up getting just a BMP icon appearing

I am trying to create a table (Access 2013) to have a few bmp images (very low size) saved as an ole data type. I keep trying to drop and drag the bmp to the table and it saves. In the column of the I am trying to save to the word "Package" appears (not "Bitmap Image"). I have also tried...

Pbaldy, Yes, that works to refresh the new fields. I am still interested in knowing how this was set up as it would be helpful in the future. thanks, Robert

First I would check in QRY_Net_Performance_Delivery to see if you have duplicate transactions on 1201368. I would simply run the query with 1201368 as criteria. I must say that I agree with CJ, you need to post code in a way that is readable. Here is how I write my SQL: SELECT...

Pbaldy, No, there is not any code running on start up. I have done a number of web searches about DSN-less connections and I have seen some code that connects like you have described. thanks for your help, Robert

Thanks Simon, I understand pass through queries and have used several times, but the query is not my question, it is the linked table. Some how the person who created the DB was able to make a linked table to a sql server backend without having an explicit odbc connection. Furthermore the...

Background: I have a DB that someone else set up and since has left our company. In the DB he has created a linked table in Access to SQL Server. The table has been modified in SQL Server and some columns added. In the past I have had to delete the old linked table and re-link the table...

CJ, thanks for the reply, I'm doing the import route already and it works fine but I want to make a dynamic procedure that I can but in variables for files. My end goal is to make a module import data from our ERP system outputs and strip off the header it puts on the file. I want to do this...

I'm trying to import a pipe delimited text file into a table. I can import the entire table using the following code, but I only get one column of data (the entire data set in one column). If possible I would like to import with the columns defined or if not possible use some code for a...

I would like to capture a command that errors and write the command or identifier to a file. I know I can use "Resume" to go back to where the code that errored and "Resume Next" to go to the next valid line of code, so my assumption is that VBA knows where it left off, I would just simply like...

jdraw, Thanks for your reply. I might not be explaining myself well. If I open a query it has a filter property. I would like to be able to use (set) that filter property from VBA.