Recent content by harleyskater

I am having the same problem. Did you find a solution to this Vince?

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

I do not know toooo much about Access but I would try to create a new access file and copy and paste everything into it. Like a new MDB or ACCDB :)

No problem! We should all take a break : )

thank you guys : )

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 :)

LTotal = DCount("po_num", "dbo_purchase_orders", "po_num = '" & Forms![purchase orders]!po_num & "'") That works!

I am still lost on this. I am going to check out your link but the first 2 DCount's return 0 and the third Dcount returns 249! It should return 3. I am going to take a look at your link. Pbaldy :) LTotal = DCount("po_id", "dbo_purchase_orders", "po_num = '" & Me.po_num & "'") LTotal =...

yes it does! i dont' have time to try it now! time to clock out, but the single quotes was not part of my vba coding vocabulary yet hahah maybe i bet thats it! <3~!@ thanks to both of you guys.

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

Awesome! I will try to put some of that code into action! and see what it looks like! - Do you know any good tutorials on record sets? and VBA. I want to learn that side of access :)

Not quite, and sorry for not answering your question the first time. It works like this. There is a form which I have for looking at all the information all the way down the waterfall I spoke of to the operations table. jobs_and_quotes->po_items->part_items->operations There is a combo box...

I have a large database- almost 30 tables. One part of this database holds what we call templates. Its basicly a generic version of a set of records. We hold that generic instance in the templates table so we can pull one of those templates into our real table and then make changes as we see...

I am in the process of doing that right now. I am setting up a test DB on my SQL backend and I am going to give it a try. Reason I posted is because I don't understand how VBA uses the insert statement. I was hoping to get a response about maybe it wouldn't work because of the way the code...

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