Search results

  1. W

    Next Record Not setting values

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

    query append with a custom function

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

    DB Design Conundrum

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

    DLookup Issues

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

    Updating Master Table

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

    How to populate fields on a new record

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

    Detecting Change

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

    Print DB configuration Details

    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?
  9. W

    RecordSave Coding

    Is there a difference between DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Close acForm, CurrentForm, acSaveNo and DoCmd.Close acForm, CurrentForm, acSaveYes
  10. W

    Calling Public Function in a form

    I am trying to call a Public function from the VBCode executed on a cmdButton click. I have a startMetricsDatabase (standard module) with the following code: Option Compare Database Public CurrentForm As String Public PreviousForm As String Public NextForm As String Public CurrentXID As String...
  11. W

    Passing variables to forms

    I am trying to pass the following variables between multiple forms CurrentForm PreviosForm NextForm ProjectID The intent is to simplify the code for my Back button, and "Open next Form" button. The next form typically is opened with a where projectID = projectID from current form. I have...
Back
Top Bottom