Search results

Hi all. I am stuck trying to find a solution to DNS-less connection between an Access 2010 front end and SQL Server 2008 backend tables using SQL Server authentication. The current environment/ application uses Windows authentication for access to the Server. I want to switch the application to...

Hi all- I need some help with subforms and subform controls. I have been searching high and low without success. What I am trying to do: I am trying to make a procedure (in a module) that can be called from any form that will change the form backcolor, as well as the color of any text boxes &...

Hi all, I am having trouble trapping runtime error 3022 (duplicate value in a field with no duplicates). For the table in question, when a user adds a record I use code to find the max index number and add one to it for the new record. This works well. However, my current project has...

Hi all, I need some help creating a search query that has multiple fields & wildcards. I just can't get it working. I created an unbound form with text boxes for each field that a user can search on. the default value is "*" for each box/ criteria. After the user fills in their criteria, they...

Hi all, After several months on hold, I am again trying to develop a project with a treeview. I have downloaded around 8 samples I found laying about this forum. Unfortunately, every single one opens up with a "No object in this control" error... even the ones I was looking at successfully...

Hi all. I am planning a new project and am hoping to get some help with some of the functionality I am struggling with. Thanks in advance for your input... THE PROJECT: Organizing task instructions for various "stations". There are a number of stations where tasks are performed, call them A...

Hi all- I thought I had successfully created workgroup security! I created a workgroup for a split database (front end on user's pc/ back end on shared network) containing 3 groups- Developer, AppUser, AppViewer. I also created a single user for each group. Everything works fine on my pc...

All, I have been looking through the board and just can't seem to find this simple thing... At setup, my users can specify a filepath to save various things to. I would like to verify that the filepath is valid. I know how to look for a specific file in a folder, but I'm just not getting...

Hi all, this is my first post to the board. I’ve been searching through the forums but haven’t been able to put all the pieces together on my problem. First some background on my application: I have 3 tables ISSUES, UPDATES, and PRTS. Each record in ISSUES has several records in UPDATES, and...