Search results

I maintain an Access DB for a friend who runs a business. The problem I am having is that the auto-number value on his machine is different than on mine so anytime I try to add data in testing, it tries to create a primary key value that already exists in the table. Can I set the auto-number...

Correct, you cannot mix bold and normal text within a label. I believe Access 2007 and later has the memo which you can use for that. To mix bold and normal, yes I am using more than one label and I guess you could refer to them as overlapping. The computers do not necessarily have the same...

I guess that method didn't work out so well. There is still a lot of inconsistency in going between PDF's and actual printers even when the preview looks right. Any idea why this is happening with Arial? One solution would be to use Courier but I don't particularly care for the look of the...

With Courier, the text alignment was the same on both computers, so something is happening with the Arial font. When I changed my default printer to PDF creator, suddenly the text was misaligned like on the other computers, so I guess I need to design the report using the PDF creator as default...

I have a report that was created on my computer. When this report is opened on other computers (2 that I've tried) the text alignment is way off. Originally I thought it had to do with printer margins dictating something but that is not the case as the margins remain identical on all...

Yes, that is correct. The contract contains something like 45 paragraphs of text. I did actually put each paragraph into field in a table with a sortable numbered field to keep them in order and that actually works better than I thought. It takes up 5 pages.

I have a contract full of text and legal blah blah blah that will be 7 or 8 pages when printed. Seems the detail section of a report is limited to 22 inches. Other than putting all of the contract text into a table and running it as a continuous report to get multiple pages, is there any other...

OK thanks. We are going to be upgrading to Access 2010 in the next few months so then I guess I can utilize the memo field for that. I will check out that link though.

I am using an actual label as shown by the arrow, not a text box. Because you can't mix normal and bold text within a label or text box, when you want a bold faced word you need to create a separate label or text box and place it within the other text. Here is an example of the difference...

I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it. This makes alignment of paragraphs tricky, especially when you are trying to insert a...

I did have pizza last night, that must have done it :o This is the code I am using, now functional with the ## Dim sql As String sql = "INSERT INTO tb_Alarm_Clock (Job_Number, Due_Date, Notes, Sent) VALUES (" sql = sql & Me.Job_Number & ", #" & DateAdd("d", -21...

OK, this was just an momentary lapse of brain on my part. When I was writing the date value to the table I failed to put it between ##. It all works fine now. Thanks for the replies and sorry for the false alarm :banghead:

I have a table that contains a date field. Normally this field is populated from a form where the user types in a date in the format of mm/dd/yyyy. This works just fine. In some instances I am using VBA/SQL with DateAdd to populate the field to contain a date 3 weeks prior to another date...

I've looked up a few code samples online but haven't gotten around to working on it yet :)

Oops, sorry I didn't recall that being mentioned in your original answer.

OK, I will look into that. However, this isn't going to fix the issue with the missing reference is it? The missing reference causes Access to give false errors.

Didn't even realize that was an option. So when I have this: Dim olApp As Outlook.Application Dim olnamespace As Outlook.NameSpace Dim olMail As Outlook.MailItem Set olApp = New Outlook.Application Set olnamespace = olApp.GetNamespace("MAPI") Set olMail =...

The database I work on has 3 users. Only one of the users has Outlook installed and uses it through Access for emailing information to customers. The other 2 users do not do this and do not have Outlook installed. The problem I always face is that anytime I copy an updated MDB to the other 2...

OK, well now he is contemplating upgrading to Access 2013. Does anyone know what kind of differences might be from 2010 to 2013?

I just tried to do that and the driver install stalled because the actual printer needs to be connected to my computer to proceed. I will look into the changing the margins through VBA though and see if I have success with that. Thanks for the help