Background: I have a front end GUI built in access where I have linked tables to the back end. About a dozen different tables. The front end has several dozen forms performing any number of functions via vba code that I’ve written. Obviously much of this vba code involved querying those tables. Both the FE … Read moreDoes linking tables in my front end to the back end cause a slow down?
I am updating a voter file which includes precinct. Precincts are sub divided using a decimal point followed by three characters so precinct 35 could be listed as 35.001, 35.002, & 35.003. This makes 3 values for precinct 35 and I only care that the voter is in precinct 35. How can I remove everything … Read moreHow can I remove part of a value when uploading new data to my table?
I have a subform-splitform that mirrors a query based on a table (looks just like the table). One of the fields in this form is a list of tasks. I’m trying to come up with a way to easily provide the user with instructions on the different procedures involved with that task without them having … Read moreDealing With Long Instructions For Split-Form Field?
I have a set of tables I created to help me manage data from a third party vendor, that comes out of their reporting tool. All was well for two years, until just recently they announced they were going to move to a new system. Now, the data is not importing without error. I get … Read moreType Conversion Failure and other errors – help please
Hi I’m fairly new to access and wondering if anyone can think of a way to do what I’ve done in Excel. Based on when the last and next day off work is, I’m trying work calculate what day someone was working out of how many days. For example if they worked normal working weeks … Read moreCalculating days in a working block
Introduction So far we have worked extensively with only one type of Control: the TextBoxes on Form, enabled with Events to Raise and capture in stand alone Class Module, in various ways. We have done demo runs to capture Events Raised from Form, like: AfterUpdate and LostFocus, in Class Module from several Text Boxes. The … Read moreWithEvents and All Form Control Types
Hi, I have a MS Access Database. I’m asked to develop a website for the form entry and the data entered in the form is supposed to get stored in MS Access Database when clicked on Save Button. How do I do it? Can I use wordpress for Web development or the traditional Web development … Read moreWebsite for Form entry linked with MS Access Database
I have created a database to track the inventory in my culinary school where I also work. I have a table set up with three columns, Item Name, Quantity, Location. For example, 12 qt Stock Pot, 7, Production Kitchen. Mainly, I have just been running queries based on Location name so I can pull up … Read moreCreating an inventory report
Hello Everyone. I have a Main form which is linked to a sub from. Can I set some of the fields in the subform to be equal to fields in the main form, then hide them? It’s not since the fields aren’t in both tables, I can’t just link them, and the sub form seems … Read moreForms and subforms
Is this a known bug? I have a 32-bit MS Access application which has been working perfectly on 32-bit Office installed on 32-bit or 64-bit Windows 7, 8, and 10 OS. Recently, we had new DELL PCs running Win 10 Pro 64-bit and pre-installed Office 2013 and 2016 64bit. I normally install Office 2010 32-bit … Read morePossible Bug – Dates converting to number/text