Search results

Guess i'm not sure what you mean by a linked Access Database. the tables are as follows SQL Parent Form FacilityID - int (PK) Facility - nvarchar(50) TabletRatio - int Notes - nvarchar(max) (Allow Nulls) SubForm RowID - int (PK) FacilityID - int Name1 - nvarchar(50) (Allow Nulls) Name2 -...

1 - Removed the WHERE Clauses and same results 2 - Removed both RoundUp and Nz and get the following when trying to enter data in the next field The Data has been changed. Another user edited this record and saved the changes before you attempted to save your changes Re-edit the record Are...

The 2nd query doesn't run until after entering data in the MaxUsers field so not sure where I would put a pause. I'm about to head out for the day so I will try this and report back tomorrow. Thanks again for your help

CurrentTabletCount UPDATE TabletCalculatorFacilities INNER JOIN TabletCalculator ON TabletCalculatorFacilities.FacilityTabletID = TabletCalculator.FacilityTabletID SET TabletCalculator.CurrentTablets = RoundUp(Nz([CurrentUsers]/[Tablet Ratio],0)), TabletCalculator.CurrentBases =...

They are linked SQL tables and there are no bit fields. As far as the null values, there are only 4 fields to enter the data so the only time a field would be null is because the data hasn't been entered yet. The fields are as follows Parent Form FacilityID - int (PK) Facility - nvarchar(50)...

I converted the database to local tables and was going to submit it, however I am not getting the write conflict errors when it is local tables, only linked tables.

After changing the code to the following Private Sub CurrentUsers_AfterUpdate() DoCmd.SetWarnings False Me.Refresh DoCmd.OpenQuery "CurrentTabletCount" Me.Recalc Me.MaxUsers.SetFocus End Sub I am getting the Write Conflict error whenever I try to enter any data in...

I have a form with a sub form and that after entering data in the sub form, a calculation query is run to update additional fields, however I am running into issues with Write Conflicts when I try to update the next field. If I do a Me.Requery then I am able to select the next field and enter...

Not sure why, but I didn't include the TicketID in my query, added that and all is good as the name and number are tied to the TicketID. thanks again !!

I have a ticket form created where the tech enters the callers name and phone number each in their own field. [FacilityPOC] & [POCPhoneNumber] What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if...

Exactly what I was looking for !! Thanks again !!! I have another issue with the combo box results, but i'll start a new thread on that since this one is resolved..

I have a ticket form created where the tech enters the callers name and phone number each in their own field. [FacilityPOC] & [POCPhoneNumber] What I would like to do is change the name field to a combo box so they can select it to see a previous list of names and numbers to select from, or if...

Tried it in all 3 browsers with the same results, but I can copy and paste the URL and it works just fine. Its just when clicking a link within Access or Excel as well Junes code does work to launch the URL, however if no URL is specified, it opens windows explorer to This PC.

It is working again, however if I don't have a URL in the Me.tbxLink field, it just opens Windows Explorer to This PC

yes, they used to work fine. I've also tested this same URL in Excel and i'm getting the same results. If I let it eventually time out and it comes up with Unable to open "URL". Cannot locate the internet server or proxy server Wonder if its a Microsoft thing as it it works in LIBRA Office...

after looking a little closer, it appears that only "HTTP://" URLs are affected whereas "HTTPS://" URLs are working just fine

I have a couple fields in my database that are clickable links, were the URL is entered into a different field and the link references that field. URLField - Where the URL is entered LinkField - Field that is clicked to open the URL Private Sub LinkField_Click...

Just have a small quirk due to the macro updating fields, whenever I click in a new field on the same record to start typing, I get the message that someone has changed the record, ....., so I have to click OK and then click back in that field before I can type. but as my question was answered...

Done and Done, thanks again !!

I just put an On Error Resume Next at the start of the Function and all is good as it Zeros out the calculated fields. Thanks again !!