Search results

Thanks for the reply. It's an interesting approach for me to consider. In my case though, the reason for me keeping things to one line isn't just a grouping issue, but also to try to minimize the space needed. Some of the computer monitors at my company are small CRT's/laptop screens at 640x480...

When you say all the records show up in 1 invoice sheet, are you using a report and printing? If so, try adding in a page break to your report design.

Hello. I've created a database of my company's suppliers (~400-500 entries). It has a continuous form (SupplierList) to search through the list of suppliers, along with search tools (keywords, categories, etc.). Originally, I worked off a flat table from Excel with suppliers in the format, Name...

Just a note about costs, you can use SQL Server Express for free. I believe newer versions allow 10GB per database. It takes more more knowledge and work to setup, but if you have very large recordsets (properly indexed and queried) or you're accessing your database over the network, you may be...

Being on a network wouldn't affect SendObject. Do you have Microsoft Outlook setup and running on your computers? SendObject uses mail applications that use MAPI such as Microsoft Outlook or Windows Mail.

Just to confirm, is "acsSendReport" a typo you made on this thread, or are you using it in your VBA as well? It should be "acSendReport" (without quotes). But more importantly, you're using Access 2003. I may be mistaken, but I don't think acFormatPDF is available on 2003. It's available on...

For sending emails from Access through Outlook, the simplest option is DoCmd.SendObject. Just fill in the arguments. There are limitations on it though, including a 255 maximum character limit for the message, not being able to choose your From address, etc. A more powerful approach is to use...

One possibility is to use the Dir() function to look up the files in the document folder. From there, you can use string manipulation to parse out the type and version of the document. You can loop through the file names, keeping track of the latest version in a variable. Replace the file name...

Switching to an SQL backend should definitely help speed things up. I've personally found a large performance gain even when my database was only 5MB. And the effect becomes greater as the size of the database grows. There are a few options to migrate from an Access backend to an MS SQL backend...

Did you save? If not, your changes may not be reflected. Otherwise, you need to change nameoflinkfield to the actual name of your field as I said in a previous post. Specifically, change the control source: =Count([NameOfLinkField]) Change that NameOfLinkField to your own field name...

If it really isn't a formatting issue, then that is pretty concerning. From my experience, dates usually only screw up when a person either doesn't have the # signs when they're needed or the format is wrong, assuming they have proper syntax (ie. the compiler doesn't pop up with an error)...

I guess I should have clarified... change NameOfLinkField to the actual name of the field or textbox for links. I called it that because I don't know what the name of your field or control is. Oh, and to clarify, make sure the name of the new control box is also the same as the one in VBA. For...

I mean, create a new textbox. Change the control source for the new textbox.

Have you tried with dates after the 12th of the month? For example, January 13 to February 24? If it's a formatting issue, then at least those should be interpreted properly since there's no 13th or 24th month in a year.

One way is to have a textbox in the report footer that counts the number of links in the report. You can do this simply by typing into the textbox control source: =count([NameOfLinkField])Then for the OnLoad event for your report, you can have something like: Private Sub Report_Load() If...

It is definitely missing a " at the end of the query string. It should be: =DSum("[ReceiptCash]","tblReceipts","DateOfReceipt between [Forms]![rptReportsMainScreen]![txtDateFrom] and [Forms]![rptReportMainScreen]![txtDateTo]") Keep in mind people responding might typo, especially when we're...

Ah, interesting. Ya, I was a little concerned about where the format was going, although it seemed to work. It got a bit confusing since I wasn't sure which part of Access was defaulting dates to system locale and which one was doing US standard. Hmm, didn't know that you could handle form...

Woops, I need to stop being sloppy with copy/paste. The equal sign definitely shouldn't be there. As for formatting, it may or may not be required depending on your system locale and the way your dates are formatted in the database. @shutzy, Sorry, I think I may have placed the format in the...

From your description, it sounds like the front end and back end were split, which is generally the ideal scenario once your database is ready for distribution. These are some reasons why it's a good idea to split your application: 1) The BE data needs to be shared by everyone, so it needs to be...

Strange, it works for me. What about just: £0.00 Otherwise, there might be some other setting such as Decimal Places that you've set. Or if your data is linked to a table, you've set the number type to Integer of some kind.