Search results

Is there a way to design a query so that the column names are January, February, etc, and include anything delivered in that month? And then have the Rows total the number of records for each product type for each month?

I've been using an the Audit Trail module for almost a year and have had no problems until now. It is giving me an error message "The expression you entered has a field, control, or property nam that Microsoft Access can't find 2424. " If I remove the procedure from "Before-Update", it...

To anyones knowledge, is there a way to "work-off-line" in a split database, and then sync the data when one is done working?

As a general rule, Access does not allow a sub to be displayed as a split form. a/ However is there any way to override this to allow the split form? b/ If not, then is there another way to somehow use nodes with +/- to Hide or display the form for a particular record in a sub while...

I know this is possible because I've done it on other forms, but I have no idea how I did it. How do you make it so that the subform resizes itself to be just to right size for the number of records?

With my form open, I want a button that when clicked will create a new record using VBA and save it in my table. Then I want it to GoTo the record (or last record in the table) in the current form. The following code does all of the above, EXCEPT it goes to the last record of the form, rather...

I have a report which groups shipments by material type. It lists [Shipment_Table] fields shipment number shipment date Number of Trucks [Materials Table] fields Material_Type No_of_Material My problem is displayed below: Shipment_NO Date Materials #Trucks 1...

I have a main form with multiple subforms. Recently some of the subforms ONLY display if there is an existing related record in the underlying table (for the subform). If no related record exists, it doesn't display. I want it to display always (whether there is a record or not) so that if I...

I want to lock archive records so that they can't be edited, however I want them available to users for viewing. So for example if the file is "closed" the record can not be changed.

I want to hid the page footer on all but page one. Here is my code, but it doesn't appear to work in print preview... Private Sub Report_Page() If Me.Page = 1 Then Me.PageFooterSection.Visible = True Else Me.PageFooterSection.Visible = False End If End Sub

ConcatRelated("serial_no","packages","[Release_Status] = """ & "Released" & """" AND ","[Package_Type] = """ & "[Package_Type" & """") I've tried this many many ways and I wind up getting either a list of all the "released" packages....of all package types, OR All of the packages of one type...

I've used this function before succuessfully, but it's not working now. I am getting the error Undefined function 'ConcatRelated' in expression. I thought maybe something was corrupted, so I deleted the module and created a new module, but that is not helping.

I want to filter the selection options of a dropdown [Serial_Number], based on the item type [container] in the parent form. How do I go about doing this?

http://www.access-programmers.co.uk/forums/showthread.php?t=236127 After looking at the forum options, perhaps I posted this in the wrong forum. I need to develop a database that will automatically assign trailers for shipments during a specific time period. See the attached link for...

I need to build a database which assigns trailers, for a specific date range, for shipments so that trailer usage is as efficient as possible. Essentially I need to have the following inputs: Trailer# Shipment# Related Shipment# (for return trips so that the same trailer will drop off a...

I need to develop some code that will schedule and track availablilty of truck trailers based on our shipment schedule and maintenance. What I would like to do, is develop an Event Procedure that will assign the trailers automatically to shipments based on their availablility. *Tables*...

Essentially what I want to do is use the tab caption as the criteria for the query. So that if I click one tab it will use one criteria, but if I choose another it will use that criteria. Is that possible? I understand that I can create a macro and open the form with a filter. But the...

We've been sharing a database with another office on the east coast, while we are on the west coast. The back-end resides here with us and we have been doing this for about a year and a half. While it doesn't always work great or speedily, it has worked and updated data so that we can share...

Is there a way to add weights for related records in a query? I have Shipmenttbl Shipment # Materialstbl Material Truck1 Weight Truck2 Weight Truck3 Weight I'd like to have Shipment# Total Weight Is there a way to do this in a query?

I have a user who has a front end copy of the database on his desktop. He often gets a lock file on his desktop that does not delete on closing the database. To get rid of it he is forced to reboot his computer. Any ideas on why this is happening?