Search results

I recently split a database that I have been working on into a sql backend and an Access front end. The split process was handled by my company's IT department. Prior to the split all forms, reports, queries, and tables loaded very quickly. However, since I received the database back from IT...

I am using the following code to open a form in my application. However, I am getting a 3075 error code. When I isolate the first portion of the Where clause the command works. Which leaves me wondering what I am doing incorrectly with the rest of the code. DoCmd.OpenForm "Commercial...

I have a user that is reporting they received the attached error from a data entry form. He claims that he began entering the record but became distracted by another matter. When he finally returned to the record the error was displayed. Additionally, he is claiming that his copy of the...

See attached picture. I have to set up a bunch of reports which will have some varying data fields. I will be using filter forms that allow the user to select what they want to view in the report. Once the desired information is selected the report is filtered via a where clause. My question...

I've looked through the archives for posts about this error, but I can't get a good handle on what is causing it in my situation. I have a main form with currently one subform, there will be another subform in the future once I can get this error sorted. The subform is used to create a test...

I have a data entry form in which several of my fields use the percent data type. Works great on all but one. The problem that I have is that I need to allow entry of values less than 1%. The problem with this is that when for example my users enter say .98% access automatically converts .98...

The project that I am working on could potentially need to move to using unbound data entry/edit forms instead of bound forms. I am not excited about the prospect, but I need to research it nonetheless. Here is what I will need out of my data entry form. A single form will be used to populate...

The decision has been made that the database that I am currently working on will be split on completion, with the backend being migrated to SQL Server. One of the main issues that has been discussed with this proposition is the ability to add new columns to the backend tables. Here is a basic...

I am trying to filter a split form using a multi-value list box. It is necessary to have the ability to include multiple values in the "Base Model" filter, but I want to see everything when there is no selection made. I have used the following code: Dim strWhere As String Dim ctl As...

Creating an access database for work. Users will use a split form with only the datasheet visible to review and manipulate numeric data. On the form I have built in quick filters that consist of of textboxes in which the values are either raised or lowered with arrow buttons that have on-click...

Creating an access database for work. Users will use a split form with only the datasheet visible to review and manipulate numeric data. On the form I have built in quick filters that consist of of textboxes in which the values are either raised or lowered with arrow buttons that have on-click...