Search results

I have multiple copies of a back end of a database that are shared throughout different offices in my organization. Each office needs to have separate databases but I have a new requirement to generate reports for the organization. The issue I will have is the Primary Key is an auto number...

I haven't done any new developing in Access 2007 and I am wondering if there have been any advances in the form size to screen resolution issues in the new version. I normally create databases that are used in my office only; all the monitors are identical and are LCD so the users really only...

I have a report with two subreports on it; there is no record source on the main report. The criteria for the report comes from a form where the user selects the report type, the start date and end date. Then they click a command button that opens the report in preview for review prior to...

I have seen several ways of doing this around here but would like to know what is the correct or preferred way? For simplicity lets say I have the following table structure and these are single parents with children: TBLParents: ParentID (PK) FirstName LastName TBLChildren: ChildID (PK)...

I would like to know if it is possible to edit database tables in SQL 2005 directly. I am decent at Access databases and can work my way through VBA & SQL in that environment; I have absolutely no experience with SQL on a server though. I attempted to open the UI of SQL Server 2005 today and...

I have a report query that uses a combo box on a form to collect the parameters. I would like to be able to include an option that would be like not having any criteria at all, to show all the records. I have tried several combinations in the criteria to get it to work and haven't found a way...

I think I found a bug in 2007; I am wondering if it is new or if it is widely know about and I have been living under a rock. I did a quick search and didn't see anything about it so I am hoping you folks will let me know. I created a form in 2007 using the wizard and then modified it. For...

I have a parts database, part of it's function is to track main parts and sub parts. For instance, say main parts are laptops and desktops. Sub parts are displays, hard drives, keyboards, video cards, and so on. I have a form that would show all different types of main parts. It has a...

I am using the Auto FE Updater to update the FE's of my database over a LAN. The utility is setup and working normally for the most part, but I have one little issue that I can't seem to find any info on anywhere. There are two groups of users that are only separated administratively (not...

Well I hope I didn't mess up with the design of my database but I can't seem to find a way to do what I want. For simplicity I have two tables; tblMain & tblStatus with one record in tblMain matching many in tblStatus. I can do what I need in my head but can't figure how to get Access to do...

I have two forms, FORM1 & FORM2 (not their real names). FORM1 is a standard bound form and FORM2 is an unbound form. On FORM1 I have a command button that opens FORM2 and passes values from numerous fields on FORM1 to FORM2 for printing. On FORM2 I have a combo box that is used to set...

I am attempting to show a custom julian date format in an unbound text box and am currently using: =Format([DateOpened],"yy") & "" & Format(Format([DateOpened],"y"),"000") This results in a format like 07117 which would be the 117th day of 2007. I would like to trim the 0 from the front of...

I have a database to track parts through a repair cycle. I need to show if a part has been in the shop before based on it's serial number. I have a button that opens a form based on a query that shows records that match the current record serial and part numbers (both have to match). I would...

I have a subform that is in single form view; it updates a table that shows workorder statuses. Each record has the status, a start date, and an end date. The way I would like it to work is the user selects a status, then the start date is set to Now(), and the end date is left blank until the...

I have a subform that contains a history of workorder statuses. It shows evertime the status changes and I want to create a summary of how long each workorder was in each status. For instance a workorder might go from "Awaiting Maintenance" for 3 days to "Awaiting Part" for 2 days and back to...

I have a main form with two seperate subforms. On subform1 I have a control with an after update event to update one field on the first record on subform2. The issue I am having is that subform2 is a continuous form that doesn't allow additions and sometimes there are no records present. So...

I have a form/subform to input students into classes based on the student employee number. The control is a combo box that actually passes the StudentID and on the NotInList event I have code to open a form and allow input of a new student if a StudentID with a matching employee number is not...

I have a form with two subforms on it and I am having problems with the SQL record source for the second subform. In the first subform I have SQL that selects the top value in field2 that also matches the value in field1. In the second subform I need to select all of the remaining records. So...

I have been told that all forms should be based on a query even if you are using all of the fields and not using any criteria. I would like to know what the advantages & disadvantages of this are. Could someone please explain this to me?

I have a form that is based on a query, on the form there is an option group with two options (show all and show active). This option group is the criteria for the query the form is based on. My hope was to have a requery on the after update of the option group and have it show approptiate...