Search results

Is it possible to imbed a subreport into the detail section of a continuous report and enforce a one to many relationship? I defined the relationship between the query that the main (continuous) report is based on and the query that the subreport is based on as one to many - then I embedded...

Just a quick question for the pros. Given: Back end and front end are both Access 2007 databases. Back end is on a shared server and the front end is distributed to all users. (with auto updater if that matters) Generally speaking, is it better practice to keep all tables, static and...

Like the title says... I have a copy of my front-end db on a shared server so users can copy it to their own computers. The database is still in the development phase, and I'm still making changes to the front-end on a daily basis, then replacing the file on the server so everyone can continue...

In access 2003... Is there a way to format a text box in a continuous form depending on whether or not the value in the field is duplicated? I've tried using the DCount function on the "OnCurrent" Event of the form: If DCount("[FIELD]", "QUERY_NAME", "[FIELD] = Forms!form_name![FIELD]") >...

This is in Access 2003. In my form (continuous, if that matters), when the user clicks on the [UIC] field, I want to open a subform and display the record containing the same UIC (unit identification code). This is my current code on the click event: Private Sub UIC_Click() On Error GoTo...

This is hard to explain - so I can only hope that someone understands and knows a solution... I want to update a "JOB" field in table "PERSON" to a field from a source file "JOBS". The tables are linked via a unique id for each person, "SSN" The problem is that each PERSON may have...

I'm using the DLookup function as the control source for a text box on a subform and it is returning "#Error". But, if I open the subform on it's own - it returns the correct data. Here's the code: I don't think it's a problem with the code itself, because it works when I use it on the...

Is there any way to force an autonumber field to reset itself (go back to "1") on the first day of each month? *** Or...can anyone recommend an easier way to do the following: I'm trying to automate a control number comprised of 4 different parts: first part = 2 letters representing a...

As the title says. Is it possible to format a field so that the first letter of each word is capitalized, but the rest is not?

I'm building a report that requires me to concatenate several fields plus additional words, etc. But not all of the fields are the same data type. I have the date formatted the way I want it in a date/time field in one table (dd mmmm yyyy), and I want to append that date into a text field in...