Search results

Or maybe not? I tried both of the suggested fixes this morning on my machine and both seemed to work perfectly. In one case, I removed wks.Close and in the other I used DBEngine(0) instead of wks. I tested both and everything looked good. Then I went and tried it on one of my user's computers...

Why didn't I think of that? Works brilliantly. Thank you!

I'm been struggling with a mysterious problem for days now and I finally found the cause. Now I wonder if anyone knows how to fix it... Here's the problem: I open frmCashAccounts, which is bound to a query that draws from tblAccounts. The form has a standard "Go to record" combo box with...

I agree that temp tables are ugly. I skipped the dynamic recordset approach at first because it seemed like a lot of work and I wasn't sure it would work for me. Now I'm really glad I did because it has saved me a lot of trouble in the long run. The temp table is serving multiple purposes...

I assume you changed the names to match your field names and control names? The main thing is for you to understand what the code is doing and then change it to make it work for you. See if you can break the code apart and get one piece of it working at a time. Start with the DSum, for...

OK. That explains it. So if you select the last option it should be pretty straight forward

Access will create a combo box with code behind it like this: Private Sub cboGoTo_AfterUpdate() On Error GoTo Err_cboGoTo_AfterUpdate ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[AcctID] = " & Str(Nz(Me![cboGoTo]...

what version of Access are you using? I'm using Access 2010 and when I add a combo box to a form I automatically see the combo box wizard. You don't see anything like that?

Yeah, I didn't notice all those extra quotes the first time around...

should be Me.exin = DLookup("USD_Equivalent", "tbl_rated", "Currency = """ & Me.Currency_Name & """ And Dated = #" & Me.SailingDate & "#")let me know if that works

I wish I could help... If you were starting from scratch I would tell you to split the database into a front end with all the forms, reports, etc., and a back end with the tables. Then when you update a form you can just send out a new version of the front end without affecting the data in the...

I'm new to the forum myself, but I think best practice would be to put each question in a new thread. I think each thread should be one topic such that someone with a similar question in the future can search the forum and find an answer without having to start a new thread. I can't tell you...

Hi Izzy, I'm working on a similar sort of database myself. I used a table instead of a dynamic recordset because it was easier, though I'm not sure it's a better solution. What I did was create a table called tblTempSplits (maybe yours would be tblTempJournalEntries?) that stores the splits...

Whompa, I'd love to help you (I'm trying to help as many people as I can today in hopes that the good karma will help me get my question answered by some all-knowing access expert), but I'm not sure I understand your question. I'm having a difficult time imagining what this form of yours...

Hmmm... I was sure someone else must have come across this problem before me. I can imagine many scenarios in which it would be problematic to have the user hitting undo and changing the value of a previously saved record without being able to run code to handle that change. Am I alone in this...

Or maybe it should just be this: DSum("Amount","TransactionEntry", "Approved = -1 And GL=" & Me.cboGL)Do you just need to know the total amount approved per GL? Or is it the total amount per GL per IO? That is, could you have two different IOs referencing the same GL and have a different...

My guess would be that this requires a DSum. Something like this maybe? DSum("Amount","TransactionEntry", "Approved = -1 And GL=" & Me.cboGL & " And IO=" & me.cboIO)I'm not clear on the connection between GL and IO, though...

Try changing the code to DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, , , Me![IDProj]Then you need to make sure that you have a textbox in frmUpdate3 that's bound to the IDProj field. I'm going to assume that you name it txtIDProj. Then put this in frmUpdate3's load event Private Sub...

Encontré la solucion: The code's all fine.The problem is that you've got Detallesfrm set to Data Entry mode. Try opening Detallesfrm on its own and you'll see that it doesn't show any existing records. Set Data Entry to No and it'll work fine. (Under the Data tab on the Properties sheet.)

After looking through all the properties associated with comboboxes, I'm pretty sure that there's no way to do what I'm trying to do. I'll probably have to go with an unbound combobox on a continuous form, but I'm hoping to avoid that if possible. Anyone have any brilliant ideas?