Search results

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.

I have a subform (this subform's source object can change to one of three diffrent forms) that allows the users to filter. I have a requirement to output the filtered data to excel. I am creating a query based on the subforms record source called qryExport. I now want to pass the subforms...

An easy way to do this would be create a copy of your form and create another table for your list. In your data source for the copied form simply join the table with your list. You could create a form that opens to edit your list.

I created a new db and pasted all the objects from the old into the new. Problem solved. Not sure what happened.

I'm getting a run time error (#459) when trying to run some code. This just started happening and the code ran fine 1/2 an hour ago. The code is filtering subform on load. Not sure what the heck has happened. Here is the code: Private Sub Form_Load()...

I solved this on my own in case someone has interest. I ended up having to set the focus to an object in my main form before having the GoToPage method happen. I think the form was confused because a button in the subform had the focus.