Search results

1. I am not familiar with aggregate functions so any error I get in the query designer is meaningless to me. That's why I posted here. 2. Yes there are records that satisfy the critiera. But because I'm not an expert at aggregate functions I suspect my design of the SQL statement is incorrect...

I'm getting "3075 Missing operator in Getfirst(MM.[UPCPLU],"","") as MyPLU " error in this sql statement: SELECT MM.GID, MM.NmProd1, MM.UPCPLU, MM.FoodCat, Max(MD.Jobno) AS LastJob, MM.C3x5, MM.H3x5, MM.O3x5, GetFirst([MM.UPCPLU],"","") as MyPLU, MM.MWID, MM.ProductClass, MM.Itemdesc1 FROM...

Access 2003 on WinXP Brief database layout: MM is a master table linked to MD via a field GID. MD is a detail table with one or more records per MM record. I'm generating an SQL string on-the-fly to be the source of a listbox control. The SQL statement uses aggregate functions so I can get...

The problem is, in the debug window or my variable watch window, Access shows the number as 10.325 but it is actually storing 10.324999999. And the internal Round function does not actually round, it simply changes what is displayed, not the value that is stored. Example: dim amt as single...

I'm using the internal round() function in A2003, but it is not working. My number I am rounding to 2 decimal places is 10.325. This should round to 10.33, but Access is rounding it to 10.32. I also found an external function on the internet which has the same error. Here is the function...

Ah. So I can just do this import and overwrite all current records in the table?

Nope. Ever since Office 97, Access help has been really awful. You can't have bookmarks anymore to save object info, and the index is just useless. So I simply make my own helpfiles with mainly the objects, their properties, methods, and other info. And that means I make my own help file index...

My dev database (MDB) is the one I use for development. But there is also a version in production. Sometimes, when I produce a new report to be reviewed by someone else, I need to update my data, i.e. get all new data from the production mdb file. Because they only have access to the production...

I already know how to delete relationships via the user interface. I need to automate this using VBA code. Thanks.

MS Access 2003 on WIN XP, MDB file. I am deleting a table in the current MDB file so I can copy it from another MDB file using this code: DoCmd.DeleteObject acTable, "oldTable"But it's in a relationship. How do I delete the relationship first so I can delete the table? Thanks.

Now I put code in my Report_Nodata event, to show a message if there is no data. It is showing that there is no data. Yet when I directly open the query the report is based on, I show 1100+ records. What is going on? The query is modified by a form, then the filter of the report is changed, and...

Ok, using the period format like this: Me.txtCommGrp is actually incorrect. I checked the MS help file. I should be using an exclamation point to reference the text box control: Me!txtCommGrp. Anyway, no matter what I use I still get an error. Anyone have any other ideas? I cannot post the db...

First, here is a pic of my report in design view. This report calculates sales commissions for each sales rep (person). A little explanation. "CommGrp" is a field in a query, it is a commission group. Not all column headers are displayed for each commission group, so I must hide both the...

Based on the value in txtCommGrp, I need to hide columns, along with their column headers in the Page Header. So doing "Call CheckQuoteFields(Me!txtCommGrp)" in the PageHeaderSection_Format is actually what I need. So I was wondering if I was addressing txtCommGroup incorrectly in...

A2003 on WinXP. I have a report I run. In the PageHeaderSection_Format routine I do this: Call CheckQuoteFields(Me!txtCommGrp) But I get this error when that line tries to execute: "2427 You entered an expression that has no value." It is referring to Me!txtCommGrp. Doing "? Me!txtCommGrp"...

I forgot to add. I need the ability to attach images and files, like PDF files. This is really important. I'm doing some testing on phpbbplanet.com, and I cannot attach an image or file, even as an admin. Anyone know how to do this? Perhaps they disabled the function because it is a free forum.

As a user I prefer vBulletin or SMF. As an admin, vBulletin is the only one I have used so I like that best.

Hi, I am researching sites to host my forum. I am looking for site where we pay someone to simply host the site. I would be the forum admin. I prefer the software vBulletin, but SMF is ok also. Do you know of any commercial forum hosting companies I can look at? Thank you.

I don't know about A2007, but in A2003 anything on a report is read-only, including all controls, so you cannot change or filter anything. An Access report is intended to be read-only. You do your programming behind the scenes, but when you preview the report, you cannot change any filtering...

Showing zeroes is confusing to the user and they do not look at data that is zero. Showing only non-zeroes makes the relevant non-zero data stand out. Showing data that is not used or relevant actually detracts from the usability of an application.