Search results

I strongly suspect that it did .......AND we've had a lot of data server issues over the past month.

Hi All - A legacy database that I've been "gifted" with managing is returning an error on two calculated fields when I open it. Actually when I open the report, "Calibration Due Report," from the Main Menu, I am first presented with an "Enter Parameter Value" "Format$" msg box. I click ok and...

I changed =Format$([calibration date]+[frequency number],"mmmm yyyy") to =[calibration date]+[frequency number] and guess what? :-) It works just fine. May not be a fancy font or color but it works. I'm thinking the ActiveX connection was the issue.

I'm wondering if the Format$ portion of the expression is even necessary. I doubt it and I'm wondering if Vaughn (the OG developer) was trying to do something with the formatting of the calculated textbox that we don't in actuality need.

Hi jDraw and Gasman, In attempting to create a new db by importing the required tables and forms, I'm thrown an error stating "There was an error loading an ActiveX control on one of your forms or reports." This reminds that when I first took a look at this the other day I received a message...

That's the thing. Nothing to my knowledge has changed. No one here - except for me - has any experience with Access at all. And I haven't ever touched this DB at all. The only thing that I know of that may remotely have had some effect is that the network was overhauled recently but that...

Hi All - I've inherited management of a legacy DB at work. The DB was created by a gentleman who is of course no longer with us. On top of that his naming conventions leave quite a lot to be desired and the DB itself is ponderous to put it lightly. In any regard, I have a form (Calibration...

Thx! It's going really well finally. Now I'm just working through the minor kinks. We've been using the DB for a year now. I initially wanted to use it on two rugged tablets in order to collect data. The owner is so excited about having usable information rather than just recorded numerical...

Hi jdraw! Yep - all is well....and getting better all the time. Hope the same for you!

Thank you - again!

That worked. Wow - A LOT of quotation marks! lol..... I don't understand the second set ( " ' ' " ).

This is triggered by clicking a "Save" button.

Private Sub cmdSaveClose_Click() ' This procedure checks to see if the data on the form has ' changed. If the data has changed, the procedure prompts the ' user to continue with the save operation or to cancel it. Then ' the action that triggered the BeforeUpdate event is completed...

no

Hi All, I have a form that has a text box that is meant for inspection notes. When I try to save out of the form I get an error message whenever the notes include a hyphen, comma, etc. This is a problem as it is routinely necessary to add a fractional dimension in the notes (e.g., 1/4"). How...

Hi DBguy! That did the trick! THX So what exactly does the hashtag do?

Hi All, I am havnig an issue with a hyperlink not wanting to remain a hyperlink after data entry in a form. I have two tables we'll call Table1 and Table2. There is a field in Table1 called "Photos" which is formatted as a hyperlink datatype. If I have Table1 open I can paste a link address...

We do have SQL Server but I do not have - or should I say - will not be given - permissions for that interaction. :-) I'm certain.

Hi All - In our mfg inspection db, I enter new (upcoming/not yet started) jobs. Basic data will include scheduled start date. This may be next week or four months from now or something random like 37 days from now. In other words, not every 3 months, 6 months, etc. I would like to have Access...

I figured it out. I forgot I had the following on the Load Event Form2. I added the correct lines to the opposite halves of the If...Else..........and it works. I'm tired. :) Time to stop. Private Sub Form_Load() Dim ctl As Control Dim rs As DAO.Recordset If Not Trim(Me.OpenArgs...