Search results

Hello, Please help! I originally wrote a database in Access 2003 that links to tables through an ODBC connection. Our company recently upgraded everyone's computers to Windows 2007 with Office 2007. I converted the database and it seemed to work flawlessly on my computer. However, others...

Ok, I've reviewed almost every post thus far about how to extract a specific text string from a text/memo field. I have not yet found how to extract multiple text strings from a single text field that fit the same criteria. Let me be more specific...I am using the Mid and InStr functions to...

When I run my make table query (to enter a 1 or 2 digit number into a table), the data type of that field in the table becomes "binary". How can I get that to change to double, or long integer, or some numerical format?

Hey Folks, I am trying to put results from 2 separate queries on 1 form. One query's results wil show up in the report header. The other query's result will show up in the detail section of the report. Any ideas on how to run a report with 2 queries? Any suggestions would be greatly...

I have an input mask for an IP address in one of my tables. All input masks begin with the same first 5 digits "XXX.XX." When a user tabs to this field, I would like the cursor to start at the end of that pre-populated text string so that they can type in the remaining six digits. How can I...

When I try to run the following code, I get a run-time error 2448 that reads, "You can't assign a value to this object." This applies to the message that reads "APPLY SRT'S!!. I don't know where to place this text in order for it to be visible when REPAIR_TYPE is blank. The message will be...

When I try to run the following code, I get a run-time error 2448 that reads, "You can't assign a value to this object." This applies to the message that reads "APPLY SRT'S!!. I don't know where to place this text in order for it to be visible when REPAIR_TYPE is blank. Any suggestions...

Good morning, I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to...

Good morning, I'm currently running the below codes to do several calculations in a report. Everything works great. One more option that I'd like to add in is when the REPAIR_TYPE field is null, I'd like for it to return a string that says "APPLY SRT'S!!". I'd also like that string to be...

I'm trying to get these different types of repair types to return a value. So far, they all return a "0". Not exactly what I had hoped for. Anyone have any input? Thanks!! Public Function TimeDays(REPAIR_TYPE As String) As Integer '*************************************************...

In the below code, if time is less than 0, I would like for the entire phrase to read "EXPIRED". However, currently, it shows EXPIRED and then the number of hours minutes and seconds. I don't want it to show any hours minutes and seconds. Could someone help? Thanks!! Public Function...

I have a field called TimeRemaining in my access report. It calculates the time left that a work order has to be closed in before the corporate office calls the branch and requests information (this is a bad thing). It is based on another field called RepairType. There are 3 repair types...

I'd like to add another condition to this code. There is a situation where neither the word "MAJOR" nor "MINOR" appear. In that case, in the ElapsedTimeString field, I'd like the words "ACTION NEEDED" to appear in Bold Green letters. Timeframes don't matter. I don't care how old the...

Good afternoon, Can someone help me figure out how to remove any reference to "seconds" in this vba code? I just want it to show Days, Hours, and Minutes. Thanks!! Option Compare Database Option Explicit Public Function ElapsedTimeString(dateTimeStart As Date, dateTimeEnd As Date) As...

Good morning and Happy New Year, I am a novice when it comes to VBA programming, but I feel pretty confident in normal Access functionality. I'm stuck when it comes to conditional formatting. I've developed a program that prints a report of how long a work order has been open. However, I...

Hello, Same song, different dance. I'm trying to calculate the difference between the last safety incident at each of our branches and the current date (want to know how long each branch has gone without an injury). I've written individual queries to pull out each branches max injury date...