Search results

Here is what I tried as an update query: UPDATE [C101-Raw] SET [C101-Raw].BIO = FullNameSplit([C101-Raw]![BIO]); Here is the function call: Public Function FullNameSplit(FullName) Dim LN As String Dim FN As String Dim LID As String Dim stLinkCriteria As String ' MsgBox "Input Value = " &...

The function call works fine. The general logic is to get record #1, pass the BIO field to the function. The function splits the field then performs a lookup and passes back a new value. That value is then replaces the original BIO value and saves the record. (So far this all works fine)...

I have the following code: DoCmd.OpenTable "C101-Raw", acViewNormal, acEdit DoCmd.GoToRecord acDataTable, "C101-Raw", acFirst Do BIOChg = Me.BIO Call FullNameSplit(BIOChg) ' Set BIO value to value returned from the function call BIO = BIOChg DoCmd.RunCommand acCmdSaveRecord...

I have 2 tables (Tbl-ProjectList and Tbl-HoursForecast). Tbl-ProjectList project# userid Tbl-HoursForecast project# userid week# forecasthours I have a form that displays the project list for a given userid. I am trying to write an append query to be run from a command button. The thought...

Once again, if this were just a single record on the form, I could take that route. The idea is the the form is a hours forecasting across an employees project list (multiple records) Think of it as planning hours for all of next weeks projects.

That is basically what I had originally done. The problem is that from my project list form (a filtered list of all projects for a given employee), I would like to have a hoursforecast button. This would open another form based on the table you described above. The problem is that the form is...

I have a DB Table with a dual key of ProjectName and AssignedResource. I have built a form based on the table that shows me all of the projects a given resource is assigned to. I would like to create an HoursForecasting table but am unsure of how to structure it. Ideally I would like to show...

Thanks. Simple Syntax. That's what happens when you stare at the code too long

I have a function that is parsing a Fullname then looking up a specific userid. The problem is that it returns the wrong userid from the table. Below is the code. Any ideas? Public Function FullNameSplit(FullName, LN, FN, UserID) Dim stLinkCriteria As String LN = Trim(Left(FullName...

Worked a little hokie. The logic seems backwards but I seem to have it figured out. Thanks. That saved me a ton of programming logic.

Thanks for the KB article. I'll give it a try and let you know how it works.

I have a macro that imports data into a RAWProject table. I would like to write a routine that reads through the RAWProject table, checks to see if the project# (key) exists in the MasterProject table. If it does not exist, append the project record to the MasterProject Table. It it exists...

While troubleshooting I even created a populated button and set all of the field values. They display on the form, but when Itry to save the record, it does not save and gives no errors.

I would like to code on the click of a command button that checks for the existence of a record. If it exists then open a form to display the data. If the record does not exist then open a form and set a field based on the value of a variable and default the remaining values. My on click code...

I am closing a custom add form and opening the original list. I chose not to use a popup form with modal setting overlaying the original form. Is there something else I should be considering?

Works like a charm Added the code If Me.Dirty Then DoCmd.RunCommand acCmdUndo DoCmd.Close acForm, CurrentForm, acSaveNo Else DoCmd.Close acForm, CurrentForm, acSaveNo End If

So my code would be something like If me.dirty then DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 Else DoCmd.Close acForm, CurrentForm, acSaveNo

Does someone have an example of code that detects if data has changed on a form? Something like: If change detected then undo changes else do not save the record I have an initial form that lists data (view only). I then have Add, Update, and Delete command buttons that open individual forms...

Awesome. I knew there had to be an easier way.

Is there an easy way to print all of the forms, form parameters and all of the VBCode behind them for a given database? I know I can print each form individually. And I can open the VB for each individual form and print it also. How can I print the form parameters?