Recent content by rctjoe24

Has anyone seen this before and if so does anyone know how to fix it? I've never seen this before. It appears to highlight text white, labels will have white backgrounds, command button text will have white backgrounds. Mind you nothing is set to white background for text...I don't even...

Thanks for the reply. What makes that sounds possible is that all our images on the computers are stored with the drivers for most applications stored on a network drive. So when the network drive is unavailable, the application itself throws all kinds of wierd errors. Unfortunately I'm not...

Can't seem to get around this error or find another post online about it. "OraOLEDBpus11.dll: An unexpected network error occurred." User is on Windows 7, Access 2010, Oracle 11g I'm thinking its an Oracle 11g issue but the user said everthing was working fine last week. I asked him to...

lol, i'll give it a try when I have a few minutes Thanks for your input. :D

Talk to my customer.....he would rather have each one of these apps as a seperate MDE and allow us (the developers) the ability to work on separate parts of the database at the same time without overlap and possiblity of overwrite. So I take it this probably has never been done. Probably not...

What I've noticed is that every time a connection string is opened to my Oracle server (Oracle 11), it takes a few seconds to establish that connection. When you constantly open recordsets in code it just takes too many hits and causes performance issues. I've noticed that when the connection...

Galaxiom, I've been scouring the web looking for exactly what you're talking about here but I haven't been successful. I consider myself a very experience VBA programmer with Access but I can't seem to get this to work. Do you have an example or a link that could refer me to the automation...

Just so you understand what pr2-eugin was telling you to do, Using the Environ() function will return any environment variable (system or user created) by passing its name as the parameter. "Username" is a windows system default environment variable but can be changed by system administrators...

Is the "Reason" field a bound or unbound field?

Is there a reason why you don't want to use the "Where" or "Filter" parameters in the docmd.OpenReport. In the next examples, replace rpt_ReportName, with your report name Example Using the filter (assuming Cnum is a number): Example Using the Where (assuming Cnum is a number)...

No problem, that's why i love places like this :)

did you set the report's recordsource to the same as the form used to input the data?

I'm convinced this is an Access 2010 shortcoming but I haven't been able to find it reported anywhere on the interenets.... What I have is an Access report that is extremely large. It is not developed like a normalized report in that it doesn't utilize the detail section of the report...

It can be achieved multiple ways but I believe you can create a textbox in the form footer and add a control source with something like the following: =formatPercent(Sum(IIF([Employee] = 'John Smith' and [Trade] = 'Electric',[Hours],0))/ Sum(IIF([Employee] = 'John Smith',[Hours],0)),0)...

Is the data all stored in one field in the table or is it compiled together on the form for display? Is the data hand entered into this text field? To me this doesn't seem like the wisest approach to storing your data. From the sound of it, you need a seperate record for each person covered.