Recent content by AdamAA

Hi, I have a few users who work offshore and their internet access isn't too reliable. Our databases are connected to SharePoint and when our users lose signal they get a "Some tables are disconnected" or "Click here to re-connect all tables" warning in the bottom right-hand corner...

Now this code works, but only if after editing the last record, I click on another one and don't edit it. Otherwise I get the same error. Thanks for your reply. By the way I love baldyweb, I use it all the time :)

I have some VBA code that clears checkboxes and text boxes on a continuous form, then closes the form. The problem is whenever the code reaches the record that I edited last, it throws up the error "Error Number: 3218 Could not update; currently locked" It will happily adjust all the other...

Perfect, thanks a bunch!!

Ah okay thanks that makes sense. Just tried it and all 4 columns are displaying when I select the combo field. Is there a way to display just the one column? Thanks again!

Hi all, I have a form with the combobox "PartName" and textboxes: "PartNumber", "LeadTime", and "PriceExVAT" The RowSource of the PartName combobox is: SELECT VesselsItems.PartName, VesselsItems.PartNumber, VesselsItems.LeadTime, VesselsItems.PriceExludingVAT FROM VesselsItems ORDER BY...

I have an access database linked to several tables in SharePoint. One of the tables is an inventory list that records which location stock items are in. The problem is that this Access database doesn't always sync 100% with what's in the SharePoint tables. You can make changes and sometimes...

That's great, thanks for the help and advice guys!

I have an Access 2010 database connected to several SharePoint lists. I'd like to be able to print a report (based on a query) and add that report as a .pdf attachment to the record I was looking at when I generated the report. At the moment I can save the report as a .pdf to a local file...

Thanks Pat! So what would I put in the "Total" part of the query for Weather to get it to return the value of the field? 'Group By', 'Sum', 'Min', Max' etc. all seem like they'd return a numerical value instead of the actual value of the field.

I have a simple crosstab query: FirstName and Surname as Row Headings. Date as Column Heading. OnShift as a Value (Count). These are from the table DailyActivityLogs. Also in that table is a choice field called Weather that lets you choose the conditions that day (Weather, Work, Part...

Thanks guys that fixed it. Such a strange error! I compacted/repaired, then requeried, uploaded to a brand new DB, relinked it and it worked!

I linked to an existing SharePoint table using the "Open With Access" feature, but when I open the table in Access it shows 301 records (there are 944 records according to the original table) and all of the fields say '#Deleted'. The table in SharePoint is fine, you can add new records, delete...

I have a form with a Time/Date field. At the moment you have to type in the full date then press space, then two numbers, colon, two numbers. If you just type in a time, it defaults the date to 1900. If you only type in the date, it only shows the date.. Would there be a way to make it so...

I have a form linked to a table in Sharepoint and it has an Attachments field. It works 80% of the time, but occasionally I'll get an "Invalid Argument" when I try to upload an attachment. When that happens I can attach the file directly into Sharepoint and it works fine. They are always...