Search results

SOLVED: Error that is Not an Error with Allen Browne's Copy Subform Values SOLVED: My problem was that there was not at least ONE value in each table before trying the code. Once I went into each table and added just one value to one field, the problem straightened itself out. Just a Note: I...

So this issue is still going on... I noticed some issues with not allowing data to be entered when changing RecordSource, so I created some extra forms and change any according code for SourceObject. That fixed the disallowing of data. However, the problem with the copying subform values still...

UPDATE: I think this may have to do with the relationships now. I have a main table with most tables connected to that. However, I have three groups of tables that each connect to their own intermediate table that connect to the main table. One of these groups concerns the tables mentioned...

Thanks, Bob. Just discovered this difference last night but hadn't tried changing it in this code. I changed it to Dirty = False and checked, but it was a no go.

Thanks for the reply. I tried Me.Requery in a few different areas, where the code succeeded, it provided the same results. I tried it inside Browne's code but it gave an error before it could finish. I even tried the following as a last resort since I'm not sure what else to try...

@RainLover it's a good idea to use the entire code if you want to see whether or not it is already being saved as you can throw in a MsgBox, or whatever you want, then determine if the code is truly necessary or not. I was initially thinking that the datasheet somehow could be involved since I...

You're right as long as the form is the active object. I'm guessing you'd have to write something like this to save the table: DoCmd.Save acTable, "tblName" However, I completely agree with the Dirty, an easier way to go. I was initially thinking along these lines: If Me.Dirty = True Then...

If the ID on the form is bound, it should save as Access does this automatically. But if you're worried, which is reasonable, just add DoCmd.Save after the code in the After Update code you put in. To go the extra mile you could use: If Me.Dirty = True Then DoCmd.Save End If Or just use the...

I'm not exactly sure if I got this right. But moreorless it sounds like you want people to pick from a list and then populate the ID automatically..? If so, then this can be accomplished. What I would do is have the list box have the ID included and be sure that the ID field on the form is NOT...

Issue: I've been using Allen Browne's code, and it has been working well until now. When the code runs it produces no Access errors and seems like it works fine; but on closer inspection one of my subforms is not having its values copied over... Insight: I have a main form with tabs that have...

I have a query that performs some calculations, these calculations feed into another query and produce a final value. If there are no null values everything works perfectly. But when there are null values, I get errors. What I have tried: 1) I tried to implement the Nz function for each field...

Bit of an update. Tried SetFocus to the second field on the second subform. All this did was make it SetFocus to the third field... Also tried setting "ScreenSize(CD12)" to TabIndex = 0 - even though it already is - but still produces the same result. The way I had to fix this was that I first...

@pbaldy - So your thought was definitely the right track. My code is now like this: Select Case KeyCode Case vbKeyTab Forms![frmMudCop].[fsubSolidCtrlSum2].SetFocus Forms![frmMudCop].[fsubSolidCtrlSum2].Form.[ScreenSize(CD12)].SetFocus Case Else End SelectThe only issue...

I have found they keycodes for CTRL and TAB, but using them in combination for the code seems to do nothing. Everything I can find on the net doesn't seem to show using to keycodes together, just how to disable ones (normally with ALT involved)...

Moreorless I just need to capture the TAB key and make it perform CTRL+TAB...

Tried it, but same result... Thanks though.

I have two subforms on a main form. I was wondering if there was a way to capture the tab key so that when they reach the last field on the first subform it will tab them into the first field of the second subform? What I have so far is to turn on the KeyPreview in the first subform's load...

Thanks for the replies to both. To answer your questions: 1) UserID is of the datatype text, so it can have text or numerical data. 2) I am actually overseas and was instructed that using US date system was fine, so I've always used the default US system Access uses. Any suggestions. I can...

I have a button that checks two fields in a table to see if a user has used a date in the past. The fields are UserID and Days. The code is: DCount("[UserID]", "tblGenSum", "[UserID]= '" & Me.UserID & "' And [Days]= #" & Me.txtNewDate & "#") > 0 The purpose is so that the user never repeats...

Never mind everybody. After hours of trying different things I was able to somewhat suppress the error by presenting my own message.