Search results

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.

Are you "logs" going to be saved in their own table? If so you can simply run an append query when they log in; Currentdb.execute "INSERT INTO tbl_Logs ([UserNam], [Date/Time], [Action]) SELECT 'UsersName' As Expr1, Now() As Expr2, 'Action They Performed' As Expr3", dbFailOnError This is...

could you paste your code in this window so I could have a look?

Also make sure you put the mdtmTimeStamp = now() BEFORE you run docmd.openreport It must be in this order or else you would get a 0 when you run the datediff.

Maybe I'm not explaining this well enough and for that I'm sorry. I'm starting to think that the form which contains the button to open the report is closed after you click it. For that reason the variable would be set to nothing. In addition if you don't explicitly dimension your variables...

Quickly thinking, sometimes combo boxes on the form are not "" but are actually Null. I use the NZ function like there's no tomorrow to make sure I cover both "" and Null cases. So you could try something like; Like...