Search results

Simple question (I realize the answer may not be). Is there a way to open an .ade saved from 2010 using MS Access 2007? I have commercial software written in Access 2007, I am testing the possibility of upgrading to 2010. All of our clients run 2007. When I save it as an ade file after...

Hello Everyone, It has been a while since I have posted here. I am working on a query to show information from various tables. It's purpose is to show the costs for each job. I am using an sql backend for an Access Data Project. I need to have parameters that point to a control on a form to...

Is there a way to limit the amount of entries in a subform to a certain number? I currently am trying to do it using the allowadditions property combined with onCurrent, but I need something to fire when I leave a record so that it sets allowadditions back to true. Is there an event that is the...

This should be a piece of cake for someone with a few experience years on me. I have a client for which I am building a custom database. They use this for various reasons. One main reason is to track man hours, cost, billing information on a per job/customer basis. Each of their customers has a...

I have an apparently unique challenge that I thought would be pretty common. I have a payroll system that tracks payroll per job. The entries are on a time range basis. So on job 2, if an employee (0520) works from 9:00 to 9:15 and then goes to job 3 from 9:15 to 9:30 then returns to work on job...

I have inherited a database. There is one portion relating to payroll, hours, jobs, and time sheets that I need help with. On each time sheet there are multiple employees. For each employee there will be multiple time sheets (even possibly for each day), Employees' time sheets will exist...

The layout of the tables are as such: _______________________ Code of Accounts table: Proj#/Var#/CodeofAccount/ManPower/Hours/Dollars Variance table: Proj#/Var#/MaterialCost/EquipCost/ConstructCost/StaffCost (+ Many others not related to this issue) ________________________ The Variance table...

I've got a list box that I want to filter by Year, Month and Day of Month. I would prefer using combos containing the values I want to filter by. In the recordsource of the listbox I'm using the Format([Date],"yyyy") method to get the year, month and day of month. 1. I want to be able to...

Send Email with query data I've got a database that is tracking work scope variances. There is a tendency to take a while for the engineer to approve the hard copy of the variance (it has to go through interoffice mail etc). We're wanting to move to an electronic approval process. Weekly the...

Is this possible to do? For example my form name is frmBogus Field name is fldBogus. So normally I would reference its properties like this: [Forms]![frmBogus]![fldBogus].SetFocus Would it be possible to reference these properties with varibles? Example: Dim stFormName As String Dim...

I'm trying to get the criteria for a chart to come from a form. In a form the user can select the report they won't to run and the other parameters. Instead of doing this through a parameter query I won't it to pass via string criteria (example: strItems = Me.AFENumber.Value 'Use the value...

I have several tables in this database 3 of which relate to this issue. tblMembers has several fields, but these are the relevant ones: Member ID, First Name, Last Name. tblEvents has all my events with fields Event ID, Event Name, Location, Date. tblAttendance has Member ID, First Name, Last...

I have frmCalendar form that opens when I click a picture on frmMembers. I pass the name of the form that opened the frmCalendars form to a textbox on frmCalendars. Now what I'm wanting to do is when I select a certain date it puts the name of the text from txtFormName into a variable and then I...

I'm wanting to be able to select multiple items in a listbox and then filter a report by what is selected. I have the report's rowsource as a query, the criteria of the query points to a text box on my form. I have code that puts all the selected items in a string with each selected item...

Is it possible to move controls on a form? If certain controls are hidden then, these other controls move up to where the hidden controls are located. If it is impractical to do it this way, what would you suggest? Also can you group controls on a form so that you can move them all at once? Eric

Is it possible to filter the values that are displayed or available to select from in a combo box? What I'm looking to do is on a form have a combo box that looksup data from a PO table; however, only display the PO's that have an AFE Number that is the same as the AFE Number on this form...

I'm wanting to know if it's possible to set the value in a control on a form equal to the record number that it is on. I have a Master form and then a subform on it setup as a columnar form. You know how the records on the subform are number per each record on the master form, like master form...

The database I have is more complex than what I have here but for the sake of saving typing I've tried to make it easy. I've been on this the past couple of days and really haven't been able to get anywhere. I've searched the forum for something and found something similar, but it was an...

I'm wanting to set up a macro or something else automatic to import an existing database table into the database I'm working on. In the macro I'm using the Transfer Database action. I'm wanting to automatically import a table from an external database. However, I want the user to only select...