Search results

Is there a way to hide detail in a report but still have it do calculations? I currently have calculations in the onPrint sub that I would like to still still calculate however I don't want to actually view the information, rather I just want to see the totals at the end of the report. I've...

I'm looking to write a script that can create a PDF form. I have a form within Access 2007 that the user partially fills out and email to another user. My intention is to have them save the the form as a pdf with several entries for the next user to complete and send back. Is it possible...

I am looking to combine a tables with multiple queries into one table. I have I have a table that contains a field [LEM] which is common to all 4 queries. The 4 queries each have 2 common fields and 3 different fields. LEM_A - LEM - WO - A1 - A2 - A3 LEM_B - LEM - WO - B1 - B2 - B3 LEM_C...

I have a subform with a list box that references a control on its parent form. The rowsource works fine except that the list won't query until I right click the sub form, at which point a menu comes up that like the following: ------------------- |subform > form | |Cut |--------- |Copy...

I am having some issues opening my Access database over the 2x server. The front-end of the database does open, however when it queries the usernames for the login page I get the follwoing error: Could not use 'E:\db\mydb.accdb'; file already in use. The file is in use by others using the...

I am trying to execute a script on the detail section of a report that(calculates employee efficiency). However I don't want to see every entry, I just want the total which is displayed a footer. So what I've done is I have reprot with an on Format script that does the calculation. And then...

I am trying to automate mail merge from access to word and within Word use Acrobat PDFMaker Office COM addin to send emails with each record saved as a pdf and attached to an email. I am able to do it manually but I'd like to automate it,does this sound possible? I tried to record a macro...

I want to be able to query records from weekends. I have a query to filter between two dates, but I'd like to filter all saturday's and sunday's between two dates. The idea is to query weekend hours of employees. It would also be nice to be able to query say all monday's or tuesdays or...

Can a slice of a pie chart be divided into smalled sub slices? I want to look at our company work orders, and see how employees spend their time. I want to know how much time they spend on customer work orders vs time spend on assets, and Sales. And with Customer work orders how much time was...

I am unable to filter one of the fields in a table, the field is indexed and allows no duplicates. I also appear to be occasionally losing data, does this sound like a corrupted database? I have repair and compacted and it doesn't change that I can't filter the records.

how can I check if a form is open using vbscript, I am trying to get a value off a form that may or may not be open. I don't want to run the script that checks gets value if the form is not open because I end up getting an error. Anyone know of a way to find out in a form is open or not.

I was saving a record and a popup came up and said others were changing the same info which i don't believe actually happened, since only me and other guy actually use it and he was gone. Either way it asked if I wanted to drop the changes and I believe i pressed save changes. On doing that...

I am using a dlookup to find a record this is my code: DLookup("[Total Hours]", "TimeCard", "[Employee]=" & "'" & [employeeTextBox] & "'" & " AND [Job Date] =" & "#" & [tuesdaytxt2] & "#") tuesdaytxt2 is a date text field with a medium date format (day/month/year) i.e. May 1/08 = 01/05/08 but...

I built a ms database and I'm just wondeirng about the compatability of using 2007, what kind of issues can i expect to run into and does this sound like there will be a major overhaul needed in the programing, or should it be pretty straight forward.

I am trying to create a chart that displays employee efficiency per month. I want to to be available on the employees record. So I created a query that retrieves the date, employee ID, rating and that works fine. but when I make the chart and I choose the efficiency query I get an error...

Is there a way, aside from using auto number, to find a records postion. I am using a list and want to be able to double click an entry and have it open a form and go to that record. However I can't use auto number because I allow for the deleting of records, and once deleted the auto number...

I am making a code that has a format like this A-##-##-##-## B-###-## C-## I'm not sure what I would use in vbscript to be able to extract the letter, because it is that letter that determines the input mask of my text box. Basically what I want is for a person to input their code and if they...

the table I'm referencing when using runsql code in vb, can it not have spaces? Cause I can't figure out what is wrong with my code other than perhaps it isn't able to find the table I am referencing. My Code: Dim SQL As String SQL = "UPDATE Work Order Content SET [WO Status] =" & "'" &...

I'm using a button a remove entries in a listbox using this code, _________________________________________________________________ Private Sub removeCompanyBtn_Click() For i = 0 To Me.customerQueryList.ListCount - 1 If (Me.customerQueryList.Selected(i)) Then...

I have a list box that is updated by a query, here is my query: _________________________________________________________________ SELECT [Work Order Content].[WO ID], [Work Order Content].[Work Order Number], [Work Order Content].[WO Date Ordered], [Work Order Content].[WO Date Needed] FROM...