Search results

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

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

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

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

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

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

Hi All, I'm working on a database at the moment that is being constantly updated and tested offsite. What I normally do is email the new database to the user, and they have to uninstall the old one and install the new one. Is there an option anywhere to make the uninstallation process...

Hi guys. I filter a continuous form using several criteria that form a string called strWhere. Then there is an On Click bit of code for First Name so when you click on First Name in the filtered form it opens a second form that allows you to enter more detailed information. Here is the code...

I have a button that lets you filter a report by date (you can choose the start date and the end date and it will bring up all records in between). Then it puts all the records into one PDF and I can email it. What I want is for each individual record to be it's own PDF. I have seen a few...

Hi, I have a form that filters a report based on a date range and it works perfectly. What i'd like to do is modify it so that it also filters by the value selected from a combobox. Here is the code i'm using that works: Private Sub Command1_Click() 'On Error GoTo Err_Handler 'Remove...

I have a table with First Name, Last Name and Current Position columns. I have a second table with a First Name lookup to the first table, but also other columns like 'Time on Shift', 'Time off Shift', and 'Overtime' (I know lookups are bad, but these are tables from Sharepoint and it's an...

Hi, I want to press a button on the Subform, have it save the record then move focus back to the Mainform. Then make the Subform invisible. I've tried this so far but it won't work: RunMenuCommand SaveRecord GoToControl Forms!MainForm SetProperty Control Name Subform Property Visible...

Hello all. I'm Adam, I'm new to programming Access, but not new to using it. I'm attempting to use it as a frontend for Sharepoint as we have many people who work offline and need to sync their information when they get back to an area with internet. I know a bit of VB but not much VBA (so...