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...

Thanks for your reply, however in the end I just created a new table with the format I wanted and looped through the queries to populate the table. Not my ideal solution for this but it works.

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...

Thanks Bob, I ended up getting working on the Current event. I didn't realize the subforms loaded first, thanks for the insight.

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...

Deleted this entry

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...

Actually this runtime solution will likely work for me, I actually didn't know about it, I was just trying to disable everything in Access 2007 to prevent users from changing it, and I had been wondering how I could do exactly what runtime appears to do. Thanks, I'm going to give runtime a try.

anyone know why this code will only work when I've opened my database while holding the shift key down. DoCmd.ShowToolbar "Ribbon", acToolbarNo I need this to work when the user opens the database without holding the shift key down as it will be disabled. Are there rights that need to be...

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...

Is it possible to delete the entries from a select query where job date does not fall on a weekend. From what I gather its not possible, if that is the case does populating a table from the query and deleting entries based on the dates sound like the way to go with this? Before I attempt...

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.

wow that was simple, thanks.

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...