Search results

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...

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...

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...

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...

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...

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...

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 have a form (frmCommoditySupplierSpend)and a subform (frmCommoditySupplierSpendSubForm1ByVend). I have a control button in the main form that will scroll down the page of the main form to a point I desire by using: Forms![frmCommoditySupplierSpend].GoToPage 1, 0, 9250 The problem that I...

I have a subform that is purely to display information (no edits will be made on it). The subform has a special color on it (company color) that I can not deviate from. My problem is the first record in the subform (displayed as a continuous form) gets the focus. The font is white and...

Hi, I would like to use a connection string to run queries that I have created in Access 2007. In the past the odbc link prompted the user for an ID and Password. I would like to just pass the ID and Password in VBA via a connection string, but I have never done this in the past, and I can not...

Hi all, I have a split form with graphs in the upper design section and the table of the data that the graphs represent in the data view underneath. I would like to make the graphs dynamic with the data from the forms if the data is filtered in design view. I know how to get the filter from...

Is there a command to return the value of what is filtered if a user has filtered a subform? My end goal is to be able to save and name the filter so it can be re-used by a user. thanks, Robert

I have a text box that is displaying a value from a table where the display control for the field in the table is a two row combo box. The text box on my form (I'm droping the text box on the form and manually changing the control source) is displaying the second column of the combobox where as...

I'm trying to check if a subform is visable. The following code is just test code so I can get a result. I keep getting an error on the .IsVisible section. Any Suggestions? If datTimePlus15 <= datCurTime And [frmBarstockAreaSubForm].IsVisible Then MsgBox datTimePlus15 & " " & datCurTime...

I'm using this control to allow users to select a date as input to a subform. The control is working just fine, but I have a problem, I need to reset the value to today on certain events (for instance a reset button to reset the values back to today). I have tried: Me!calThru.Today and...

I would like to update the SQL for a subform. I have an SQL statement that I have placed into a string and now I would like to update the subform using it's RowSource property, but I get an error when trying to use the following statement: Forms![frmModelSales].[frmModelSales-Subform-...

I'm using access 2007 and I have a form with six subforms on it. When the form is completely load the subforms DO NOT have scrolls bars (for up and down) on the right side even though the data (rows) far exeeds the number of rows displayed. I have checked all the properties and all appear to...

I would like to change the color of my subform to match the color of my main form. I currently display the subform in datasheet view and for the life of me can not figure out how to change the colors, or if it is possible. I have tried setting the conditional formatting to do this, but it runs...

HELP!!!!! I am using access 2007 and my backend DB has a lock on it while every user has said they are not in the front and back end db's. Is there a way to remove the .laccdb lock? I need to modify my backend and this is holding me up from making any design changes. Thanks!