Search results

When switching between main form and subform get a 'the data has been changed ... another user edited this record ... re-edit' Hi Folks, I have an elusive issue with a set of forms I am trying to figure out. A main for with a tab control and a few tabs is opened and maximized via a command...

Thank you for the reply boblarson. I tried the code and it didn't seem to work so I verified the code by using it on other dates in a different form and it did work perfectly - thank you. This to me indicates that some other code that was being used on the same date fields that I was trying to...

Hi Folks, Due to a glitch I am working around, I need to create validation rules for certain fields in VBA versus using the validation rule property in the field property. For some reason, this code I am using below isn't working properly ... any ideas would be appreciated! Private Sub...

This seems to work: Dim FormatEmploymentDate As Date If IsNull(Me.Needs_Assessed_by_Instrument___Employment__Date) Then Else FormatEmploymentDate = Format([Needs_Assessed_by_Instrument___Employment__Date], "mm/dd/yyyy") Me.Needs_Assessed_by_Instrument___Employment__Date =...

Folks, What I am basically looking on trying to do is perhaps on the load current aspect of the form use something like this: Format(Me.Needs_Assessed_by_Instrument___Employment__Date.value, "mm/dd/yyyy") So that I attempt to alter the formatting, when all else failed, at the very last step...

Hi Folks, Basically what is happening is that if I manually created the link for the SQL Server tables in question, the dates on the forms are properly displayed as MM-DD-YYYY. However, if I via tried and true code that has worked for years automatically link the SQL Server tables in question...

Hi Folks, I am trying to slap a few on this issue rather than figuring it out, as I tried to figure it out for hours and hours on end and just need a bit of code to 'patch' it right now. I have a huge Microsoft access database front-end tied to a massive sql server back end. Tons of fields...

Hi Folks, I have a search form that opens up as soon as the database is opened, if the search renders results those results are displayed in a different (results) form otherwise the "results" form opens but it is blank/void of any records but still useful in that the command buttons on the top...

Hi Folks, I currently have a form with a tab control on it, I have disabled the navigation bar on the bottom of the form to force compliance with specific controls and data flow on the form and tabs and didn't want the user to circumvent that security by using the navigation buttons of first...

Hi Folks, I got lots and lots of fields need to be set to visible or invisible based on field content. Manually coding all of this is possible it just takes forever. This is what I am wondering (if this is possible or exists or not): If I had say 10 fields all all those 10 fields were to be...

Hi Folks, I got a form that has quite a few areas where I am trying to make certain fields visible or invisible contingent/based upon the user selection in other fields. For instance, if a user selects a specific item from a combo box, the relevant and associated fields with that answer would...

Figured it out ... I just used filter on load and [Subform]![IDField] = [Forms]![FormName] :)

Hi Folks, I have a form with a 5 tabs in it via tab control, 4 of the tabs are based on one table and one of the tabs is based on another table. The two tables share a unique key, both named 'ID' that allow me to join the data from both tables successfully. I have been trying everything to...

Hey Folks, I got a complicated issue here ... this has to do with tables and forms. I am using MS Access front end linked to SQL Server back end for a gigantic survey for a non-profit. The survey is so large that it goes well over the 255 field limit per table/form with Access. In order to...

Hi Folks, I got a strange issue: I am attempting to develop a Microsoft Access front end tied to a SQL Server back end via a linked table for a non-profit organization ... I have done a few of these programs before, but never ran into this problem I am having now. If I try to enter a new...

Folks, Thank you for the quick reply. I have tried the code found below with different 'key words' to find that nothing seems to be working. The code produces an error or does not render and error but does nothing. Any help would be appreciated: If Me.Combo188.[*KEYWORD] = "Other" Then...

Hi Folks, I have a combo box that accepts a single value from a list of items (no free entry allowed). One of the items a user can select is 'Other'. If a user selects the 'Other' item from the aforementioned combo box, it is expected that the user populates what 'Other' is in a text field...

Hey Folks, I am wondering if there is a quick and easy way to bypass the size limitations on forms. I notice that forms are maxed out at 22 inches in width and 22 inches in length. If I would like to use perhaps 12 inches in width and 60 inches in length to be able to place the needed...

Hi Folks, I have some VBA in a MS Access module that properly and successfully executes a shell command that executes a batch file in the following manner: Shell("C:\runthisfile.bat") I am trying to actually place the contents of the batch file into the module. The problem is that the batch...

Hey Folks, I have a few Access database applications that are basically just some VBA modules that are kicked off by a macro trigger ... at the end of some of these modules I kick off a shell command that essentially runs a batch file resident on the machine. These apps have worked very well...