Search results

I'm sure this has been asked a thousand times...not sure how to search on it...so I apologize if I am asking Unnecessarily: I have several queries in a database that all prompt the user to key in a value. Most of the data for this particular database is coming from linked tables. The linked...

I have a report with a list of item numbers and various fields containing related data (inventory value, months onhand, etc). It also contains a field for an item code, DI=discontinued item, N=new item and so on. The N and DI items do not run consecutively on the report because there is another...

OK, I see, duh...how stupid of me...again. Thanks!

Well, I can't figure it out or find an example for this anywhere: I have a report and I would like to have one field on the report be displayed in bold based upon the value of a different field in the same report. For example; if I have report with a list of item numbers (and various other...

Here is the Link http://www.microsoft.com/office/preview/beta/getthebeta.mspx

Just in case anyone out there is interested, You can download a beta version of MS Office Pro 2007, you will just have to do a Google search as I do not have the URL handy right now. Apparently it is a full version that goes to limited funcioality sometime in February. I had a new PC that I...

right now the field data is numeric, I think I can make it text with no problems.

What I really want to do is convert existing data. It is one of those strange reasons that I hate to try and explain (the why part) just trust me, I need to get leading zeros appended to the field data for all numbers so the field value is always five characters and is proceeded by zeros. I was...

The problem there is that I do need the leading zeros to be part of the data, if I format the field that way that is just a display property. The Format property affects only how data is displayed. It doesn't affect how data is stored

Here is a little more detailed information for you: Yes most scanners with a USB connection should just jump and play almost immediately. Basically Windows will recognize the device and load any needed drivers. Then the scanned barcode data will read into almost any application that you can...

I know this can be done, but I cannot remember how, hoping someone can save me some time: I have a field with values like this: 5 22 123 1234 I want to append zeros to the front of the field data using a query so the value in the field will always be five charactere long and will be padded...

Exactly what I was looking for...thanks, I had almost given up hope of getting a reply.

I have a report that uses data from a query. In the report header I have a text box that I want to use for the title of my report. I want to use a text box because I want the report title to be dynamic. I would like to have the text box pull a value from results of another query in the same...

Pat, Thanks for the reply, I appreciate it. The field values are location code definitions for a racking system in a warehouse. I have the location codes stored in a table and am now trying to print location labels that I have made in Acces (also using an activeX control for a barcode). I set...

Not sure if this is easy or not, I have searched the forum but am not finding what I am looking for. I need to see if there is a way, in a query to extract data specific to either even or odd numbers. So if I have a field on a table with data like this: A01A A02A A03A A04A A05A A06A I want to...

Well it is very difficult for me to explain why but...I actually need the double quote on the left side of the number: "45263 (for example) It all has to do with a business application that runs on my companies iSeries. I plan on using a macro in the iSeries Express Terminal Emulation program...

Some kind of workaround Well I found a workaround for myself; if anyone is interested: It looks like I can first copy it into Wordpad (or probably Word) and then copy that and paste it into notepad and it will be as I want.

OK, here is a weird one, at least it seems weird to me. I have a field on a table, or query result, doesn't matter which, and it looks like this: "55264 "25468 "4562 "123 etc, etc. Now I need to copy that and paste it into the notepad in Windows. When I do that the pasted data looks like...

I think if it were me I would try System Restore first C:\WINDOWS\system32\Restore\rstrui.exe If that did not help I would try reinstalling Windows.

That easy, Thanks!