Search results

I am working in Access 2007. Designing a report where I have some text boxes and I want the font to be very large - as in over 127. It looks to me like 127 is the limit. That surprises me very much. Sure, it's not often you want a font larger than that but, my reason is legitimate, and it's my...

Thanks for the replies. I have no problem with the admonition or constructive criticsm. Your point on normalization is well taken. The particular table I am working with is actually a link table from another system. So it's not my creation, and probably not how I would have done things. But...

This is an odd one. I have always achieved this by somewhat less than graceful means. I suspect there is a better way to do this. I am wondering if it can be done in a single query versus creating multiple queries and then bringing together into the final product. generically speaking: I have a...

Yes, you can use regular barcode fonts or look into activeX plugins. Depending on how much you inted to do you might want to look into Bartender. It's a great program for designing labels ( a little easier for heavy duty label designing needs than Access). And you can link to the Access tables...

By the way, I print all kinds of reports and labels from my Access databases with barcodes. It is a great way to speed up data input and improve accuracy.

Like some of the others are saying. The database itself does not really care if the information being fed into it is from a barcode or not. meaning: the field in the database will accept whatever is encoded in the barcode as long as the data matches the data type of the field so on and so forth...

I thank you both for the replies. Am sure I am can use both pieces of information. I went with Raskew's suggestion and that seems to work fine. Thanks again!

This has probably been asked many time before but, I'm sure others may need a refresher, as well as myself. I have a field in a table that is a text field. It has dates like this - Nov1005. I want to actually use the filed like a date field. How can I do this in a query? Thanks!

Pat, Thank you very much for your reply. I am not sure why the queries no longer worked. I went through the upsizing or conversion process rather hastily, as it was really just my initial test. Then afterwards it just did not behave as I had hoped it might. I need to delve into it more to...

I am thoroughly confused at this point and am hoping for some generalized help to get started. I have an age old problem in trying to share a database across a WAN to our various branches. I understand that Access does not work well at all in a non LAN environment - all good there. But, I do...

I am guessing no one has an answer to this but - what the heck worth a try: Is there any way that a person might design a form so you could view a different application inside an Access form? For example: an Internet Explorer window or an Excel spreadsheet. I have never heard of doing this so...

I'm not sure this will be helpful to you but, hopefully it might help you find a way. Here are a couple links you might take a look at http://www.taltech.com/support/Keystrokes.html http://www.taltech.com/support/bckb/bckb_dde.htm

And........that works...............many thanks!! Why is there not a more obvious way in Access to do this?

Ok, While I consider myself pretty good at designing/creating reports in Access, I seem to be stuck on this. Not sure why this has never been an issue to me before, but it is killing me today. I have a report that has disclaimer information that needs to be printed at the BOTTOM of the last...

Just right click on the 2006 report and select copy, then past a copy of the report and rename it. Then you can go into design view and change the source to the new query

Absolutely awesome! Exactly what I was looking for...thanks!

I have a text box control on a form - I have the text box disabled in the properties. I want the text box to be visible on the form but I do not want it accessible at all times. I would like to be able to enable the control by use of a command button or a check box or something. The reason I...

I could not make use of either of your suggestions. I am already aware of missinglinq sugggestion of using <Control> key then presses the <Apostrophe> key. But I don't want that because I am entering data into the serial# field using a scanner. I don't want the user to have to do the...

I have a form with two fields: Location and serial# I would like to find a way to automatically populate the new records with the location value from the previous record. What I mean is; the location field will typically be the same for many consecutive records. So I do not want the user to have...

looks to me like you need the full version of Adobe Acrobat for this to work. What has worked for me is to buy one of the many pdf conversion programs, a lot of them out there and not that expensive. Then you just print your Access reports to the pdf printer and it converts them to pdf.