Search results

Form with a large amount of records-Date entries are slow I have an Access 2007 accdb file. The problem is I have one form which is used a lot. In access 2003 as a mdb file there was no problem, but we upgraded last week and now all the dates on this particular form, if changed, there is a...

When I am using a form and I go from record 1 of 5 to 2 of 5 what event is triggered? I want to put some code that is triggered then but I do not know which event is best. Thank you :)

I am trying to use Dcount to check to see if a Purchase Order Number has been used before. Private Sub po_num_AfterUpdate() Dim LTotal As Long LTotal = DCount("po_id", "dbo_purchase_orders", po_num = Me.po_num) If LTotal >= 2 Then MsgBox "This PO# may already...

possible to use DMAX here? If 1 > 0 Then strSql2 = "INSERT INTO [dbo_operations] ( part_item_id , job_process_count, operation_num, op_type, op_description, emp_id, est_mins ) " & _ "SELECT " & lngPartItemID & ", DMax("job_process_count"...

** suggestions and open conversation would be helpful ** Attached - Database Model for the Timeclock I built a Time-Clock as part of an Access project a couple months ago. It's not 100% in use at the moment and my Access projects tentative release date is set somewhere in July :eek: This...

I need to reference a nested subform. I have a main form called jobs with a subform called items, that subform has a nested subform called part_items how do you reference this in VBA? Me.items_sub.Form.RecordsetClone - references my subform :) thank you!

I have a command button linked to a macro set up to do a filter, but I also want the button to do a sort with another macro. How do you set up a sort Macro? Appreciate it :)

Ok I think I have a simple question but I am having trouble tracking this answer down myself. If "DoCmd.OpenReport "report",acViewPreview,,," opens a report in print preview, what code do you use to just print the report without the preview "DoCmd.OpenReport "report", acPrint,,,," is not...

The copy part of this code works great but I need to set some fields to a default value after the code has ran. It will be the current record on the form : ) This is part of some VBA code used to copy the record from the current form to a new record. After those 2 functions have ran I want to...

I have a purchase order report I built. The management wants me to center the description field on rows that are for description only so they stand out more on the purchase orders. ie. Line Item Description QTY PRICE row 1 |...

I just wanted to know where people go to look when they are checking to see if their domain controller is the primary domain controller, when on the server. We upgraded last weekend to Windows 2003 r2 as the PDC from an old Win2k SBS. :)

I have a problem where I was given a list of companies in an excel sheet that are formatted horribly. 3727 Memento Funeral Chapel Mailing: 5201 Lakeshore Drive Business Unit: Canada Physical: 5201 Lakeshore Drive Bonnyville, AB T9N 1X7 Managing Dir: John Gordon Bonnyville, AB T9N 1X7...

This is what I have of course Rows(rng.Row + #).Delete is not real code, its just a place holder to show what I need. If anyone knows the code to tell vba to delete the following 4 rows please assist : ) I also have another excel vba question, I will post in another thread. Thank you...

I haven't seen a lot of information about the xml datatype that now has support with sql 2005. I want to be able to have users make selected text bold ect. from a command button so they don't have to type in the xml tags manually because to them typing <b> memo text </b> is "hard" ;) hahah I...

I was wondering if there was a setting in Access 2007 where you can make it so when you tab through fields on a form or use your mouse to select a text field on a form that the cursor will go automatically to the end of the last character. Access 2007's default is highlight or select the...

I have a timeclock that I built into my access program. That just allows employees to clockin and out. I needed to ask how to automatically through VBA when a form is closed from a click of the [X] in the upper right hand corner how to cancel the changes that are waiting to be updated in the...

I am a programmer that recently was assigned the task of building a single network site with 2 servers. The servers are both supposed to take on the role of the root domain and thier own Active Directories and are to use DHCP. Though the companies are considered separate there are 2 people that...

I have a timeclock form, that allows people to clock in and out. The recordsource for that form is a table. I want to have the form check the table to see if someone has already clocked in, so they don't clockin twice without clocking out. There will have to be some sort of code/query that...

I am not sure if this is only an access 2007 problem, or if its maybe a problem on the server side of this, I have a sql back-end on the server. If I enter data into a memo field access 2007 does this weird thing where it drops the last word to a new line. ie. ---Entry 1: Hi my name is Harley...

I want to know if its possible in a report to put an unbound text box, or some sort of text box in a report and then edit that text box from the report view. Reasoning behind this is, I want to be able to make random notes, not meant for the database underneath the records in the details...