Search results

On a subform that records notes in datasheet view (columns: Date, Note; sorted in reverse chronological order with newest at the top), is there a way to get the blank new record line to appear at the top? Otherwise, you have to counter-intuitively scroll down below the oldest entry to enter a...

Here is the code I use for a button on a form that will print a report corresponding to the current record and open up an email with the recipient blank. You can hard-code any variable (to, subject, body) by modifying this code slightly. It doesn't send the email - just opens it up so you can...

I think you should look at the left and right joins in your query. Right click on one of the arrows between your two tables. Let's say you have customers, some with orders, some without. Right now, you probably have your link to include all customers and then the orders associated with them...

These are .mdb files. I think Mihail came the closest. I first tried what Mihail suggested (making a new copy of BE and relinking my FE), and that didn't work. However, then I made a copy of my FE, and deleted then relinked the tables, and that seems to have fixed the issue. I'm not sure...

The FE that I am using is my own personal copy of the data-entry FE on my own personal hard drive - not the network (although it accesses the shared BE via linked tables). I have verified that they are running the correct read-only FE directly from their hard drives (not a shortcut or other...

I have a split database. The back end is in a public folder on our network. There are two front ends - one that is read-only (dozens of users), and one that is used to enter data (2 users). The users all copy their appropriate front end to their desktops and use it from there. I am doing...

Since the table doesn't exist, that didn't work. However, one table was linked to another database, and apparently someone else had named a table the same as my old table in THAT database, and the relationship was from there. Thanks for your help!

Whenever I try to add a new record to a form, I am getting a message that "You cannot add or change a record because a related record is required in table "TableDietOld". I did create a table with this name when I was fiddling with the database. However, it no longer exists. I am trying to...

Thanks michaelryan78! That was the kicker. No idea where I got those quotes from. The final working code now reads: If Access.Version > 13 Then DoCmd.SendObject acSendReport, stReport, acFormatPDF, , , , stSubject, stEmailMessage, True, "" DoCmd.OutputTo acOutputReport, stReport...

Thanks KCLNick and Paul. Here is my updated code that incorporates your suggestions, but still does not save the file, and returns error 2501. CB myPath = "J:\Diet Cards\" 'I removed stCaption from here so that I could check the directory by itself 'This returns a message box saying that...

The code below is from one of my projects where people prepare meat and vegetable products at different stations (tables). It does some of what you want to do, and I think you could modify it for your needs. First, the code looks to a form to see which stations need to be printed. Then it...

Thanks, but unfortunately the 2007 folks cannot export to PDF. You have to install a service pack, and our IT folks will not do this because they are slowly rolling out 2010. For whatever antiquated reasons, people regularly use the .xps format internally around here. Strange, but true. I...

I'm trying to figure out why I can email a report as a PDF, but not save it as a PDF using the code below? When I save, I get the dreaded error 2501. The searching I did for this said to uninstall and reinstall printers (I've done that - seems to have no effect), or took issue with...

Thanks - that worked! Just what I was looking for.

I print a report onto labels (Avery 5960: 3 columns of 10 labels on a letter sized piece of paper). The report and labels print fine BUT... I need physical page breaks between certain sections. When I click on "keep whole group together on one page" in the "group by" section of the report, it...

Thanks. The problem is not so much about defining density as how to code this in Access, where some things need a density conversion (volumes) and some don't (weights) and some have missing data. The ProductWeight table already has the density values for each product in it (gram weight per...

Hi there. I'm looking for some vision help: We sell "beads", and people can order them in almost any volume or weight unit they want - cups, drums, kg, lb, etc. For orders, cost, etc. it needs to stay in these units. However, internally, we track everything in grams, so I need ways to convert...

Hi there - I've been learning a lot from lurking here for the last year or so. Now I have some questions and thought I'd join the crowd. I'm fairly new to Access (1 year), although I have done various bits of programming for many years, so much of it seems familiar. I've been enjoying how...