Search results

The sort function (as far as i can tell) will only sort 1 row at a time based on contents of column selected. So say you have 3 rows of data that should be treated as if they were one. How would you be able to sort 3 rows at a time? In my situation, for example, D1=1 and D7=2 but all the cells...

I'm using an old AS400 mainframe system here. I can export a report that i want into a txt file and then import to excel but i'm running into problems when i try to separate all this data. Unfortunatly when the report exports to txt file, it does not keep the column widths as seen in the...

I want to turn off the access shell and only display what I have created. I want it to float on the desktop as if it's a standalone program. I searched the forums and I found several useful posts concerning this topic but i just wanted to investigate further. I thought I had done this once...

Private Sub EmpID_Click() Dim SQL As String SQL = "SELECT * FROM Employee WHERE (((Employee.EmployeeID)=" & Me.EmpID & "));" Me.Parent.sfEmp.Form.RecordSource = SQL Me.Parent.tabPublisher = 1 End Sub This was the code we had before Office 2007. The purpose of this code is to...

Form 1 has all the regular information for employees. Form 2 has the dates of their "progress reports" for each year (you'll have multiple records for a single employee on Form 1) Form 2 is also a popup (just a small window with a few date fields and a record selector so you can scroll through...

I have a report that is filtered based on the selections made in a form. (IE. provide a date range to look in) I want to be able to display that date range on the report. If someone could just write the proper syntax, i can plug in my field names.

I have a report that tracks Job Announcements for my organization. The report is based on a query, and inside that query i have some calculations (IE. time between 2 dates) The jobs are grouped by department, so i have a group header and footer. This is the only group. In the group footer...

I have a form (Form1), it's connected to Table1. Table1 has a "name" and a "title". Table2 is connected to Table1. Table2 has a "date". Can I show information from Table2 on Form1 if the Form is connected to Table1 and not 2? If so, what would be the correct syntax for showing "date" (from...

If you start a brand new table and enter in 5 rows of data (Column 1 being the autonumber). Then, if you delete those 5 rows of data, your autonumber will be starting out at #6. Is there a way to reset that autonumber so it starts back at 1?

So i built this really awesome, huge, complicated database. Now, I'm slowly discovering that the design was built wrong in the first place. Ahh, the power of "hands-on learning" This database tracks Job announcements and the employees that get hired. For jobs, I have a table called [tblJobs]...

Well. It seems like everytime I try to do something in Access, no matter how simple it would seem, there is ALWAYS a problem. GRR! I want to create a single page report that displays calculation results (from a query) about each different category i have in my table/query. Maybe there is a way...

I still do not understand why there are different operators for referring to the same thing from different locations. (Nor do i want to understand) Does anyone have a cheat sheet? I copied this formula directly from a form to a report and expected it to work, boy was i wrong. Here's the...

I found this nifty article on the MS knowledge base but it is for 2000, not 2003 that i am using. http://support.microsoft.com/kb/208529 Is there a simple fix to make that work in 2003? I've tried to do it according to those instructions but i have the following problems. on that link under...

sigh, It's me again! I have a subform, bound to a query. On that subform, i utilize DCount, Count, and DAvg to give a wide range of information about that query (all the jobs) So, i have a control that shows me the total number of jobs in my DB and i have another control that shows me the...

So, I have this query... This expression works fine: Expr9: Nz(DateDiff("d",[Closed Externally],[Cert Returned to HR]),0) However, this one does not: (the expression itself works, it's just that the [] + [] is concantanating and not adding) Expr13: IIf(Nz(DateDiff("d",[Closed Externally],[Cert...

So, I have this query... This expression works fine: Expr9: Nz(DateDiff("d",[Closed Externally],[Cert Returned to HR]),0) However, this one does not: Expr13: IIf(Nz(DateDiff("d",[Closed Externally],[Cert Returned to HR]),0)="0",[Expr7]+[Expr8],[Expr9]) What's the deal?

So, I had been asking this question in a different forum. Sorry if this is bad forum usage. The goal is: I have a 6 tab main form. On each tab is a subform. The 4th tab is a search subform (hrSearchJobs) that looks up information from tab2's subform (hrJobs). The search will display it's...

OK, the main goal is to display the total number of records in a table on a form. But, on this same form, I want to do the average timeframe between dates as well as 4 or 5 other quick reference formulas. (So, i can't bound this form to just one query. Building the query is not the problem...

I hope this is being posted in the right place. I have a search form that uses the "details" field to populate the search results. The search form is the 4th tab in a 4tab group. In the search result, I have a field named "JobID". I am trying to make it so I can click on that search result...