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

MSAccessRookie, thank you for the website link. May seem like a silly question, but is this an update in Access 2007? I'm still running 2003. Our company is looking to upgrade to 2007 in Q3/Q4 2010. I tried looking for the Split function in the Build button. I can't find it. I'm hesitant...

boblarson, It comes from Oracle databases that are maintained in another state. I access them using an ODBC connection.

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

John, Thanks for the input. However, how do you get the cursor to move to the end of the text string in that field. If I always want the first 5 digits to be 45672, how do I get the cursor to always be at the end of that field. Thanks.

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

Now I'm getting a run-time error 438 that reads "Object doesn't support this property or method. However, this is a textbox. Anything else I can try?

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

Hey Everyone, Yes, I am an idiot. I received a post from another site about this topic. Apparently, I had changed the default printer setting in the "Page Setup" for each report. Instead of listing as print to default printer, I asked the reports to print to a specific printer. I did this...

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

Great!! Thank you for your help!

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

Perfect! Thanks!!

Thanks for the suggestion. Now, the field that I want to read as "EXPIRED!" now is blank for that case only. Do you have any other suggestions? Thanks. Public Function TimeRemaining(TimeDays As Integer, dateTimeStart As Date, dateTimeEnd As Date) As String...

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

You have to register. Click on log in button on homepage and enter your personal information. Then, you'll have access to enter your own threads.