Search results

I spoke too soon. It still doesn't seem to work. I changed it to: If Me.Deferrable = -1 Then Me.flag.Visible = True Else Me.flag.Visible = False End If but nothing seems to happen.

Hey guys, Thanks for the help. Chose a combo box because the people viewing the report don't have the best of vision and have asked to see something other than a small check, which is what I initially had. Even the yes and no befuddles them sometimes so I wanted to add the flag image to...

It's huge. Let me see if I can pull just what I need to demonstrate the problem and get it posted. Okay...pared it down to just what is need to demo the problem. Have at it.

@ pbaldy - I've now tried both the report view and print preview, but no dice. @vbaInet - Not sure what you're referring to in your first sentence, but I'm not getting images from an image path. It is embedded, 1K in size, and the only one I'm using.

Put in the On Format event in the detail section and it didn't work. As a matter of fact, now it just shows the image regardless of whether I set the variable to yes or no.

I've searched high and low through the forums and tried every piece of code I can find, but I still can't get this to work. I've got a report with a combo box and an embedded image. The name of the combo box is deferrable and the image control is name Flag. I using the below code: Private...

Thanks! Worked great!

Hi all, I'm trying to keep a check box disabled until a specific item in a combo box is selected from the choices, i.e, Item number 2 out of the 6 possible choices. I know the after update event should trigger the enabling of the check box, but I'm not sure how to go about doing that. Any...

Hi all, I'm trying to generate a report that's pulling data from two tables. The first table contains high level tasks (TaskID, Task) an the second table contains related sub tasks (SubtaskID, Subtask) with multiple sub tasks relating back to each high level task. I'm trying to get the report...

Thanks everyone!

Found the issue....was on the form side.

Hello all: I've got an Access 2007 DB. There are a couple of tables with memo fields, but there only seems to be one table that's having this issue. When data is entered through a form and then I go look at the data in the table, for some reason <div> and </div> have been added around the...

Not using any unbound forms, or ADO recordsets (so far as I know, which isn't much when it comes to this). Tables were created and present in the SQL 2008 back end, and after entering test data in the front end I can see it in the tables on the SQL back end.

Hi all, I split an Access 2007 database and put the table into SQL2008 using the Microsoft SQL Server Migration tool. When I linked the tables in SQL to the access FE, a second set of tables was also created in the access FE. From what I understand the FE tables then update the tables in SQL...

Thanks. That's what I needed to know.

I'm asking the question because I'm not a DBA and I'm not an access developer, thus I'm not sure if there's a difference between the two methods. If anyone would care to actually be helpful it would be appreciated.

I know it's considered bad practice to use lookups on tables when doing design, but what is the thought on using a value lookup in a table where the values are set? I'm redesigning a DB that someone before me created and it's got about 20 tables that hold from 2-5 values in each table. These...

Never mind...the error was between the chair and the computer...ugh.

Hi all, I've built a simple report that uses a query to pull data. The report is supposed to display a audit name, the sum of the hours for the audit, and the budgeted hours. When I look at the query in datasheet view it runs fine, but when I point the report at the query to pull the data it...

scratch that. got it figured out. thanks for pointing me in the right direction!