Search results

solved the issue

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

Lagbolt, Songbird, thank you very much for the assist. I went with Lagbolt's example and it seems to work like a charm! I had a little trouble passing the form object, but this seems to work: Dim frm As Form Set frm = Forms!frmsetup Call ChangeFormColor(frm)

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

I do not have any code in the backend, not a single line... so I do not believe there is any way for one front end to know what another front end has its variables set to. I think I would have to be running the code from the shared back end for everyone to see it.

Thanks for the idea. I should have mentioned it is a split database, with each user having their own front end. I do not think your solution would work in this environment (though I am very tired so if I may be missing something obvious) . Is there some way to know if a record is being added...

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

I was trying to create a search form that the user could search for a value (or combination of values) in one or more fields. So I assumed if a user did not want to search on "PartNum" for example, that the criteria should "*", and so on. This however did not work for some reason...

I appreciate all of the feedback... Well, I could not get the thing to work in the query builder. While I was surfing around I found a very nice bit from DCrake that basically parses together a "where" statement based on what a user fills out. That worked very well. Sorry I haven't figured...

the inspectDate is a date field- I will correct that. But it still does not work even if I remove that criteria.

I cannot get it to work from the query builder. I can add Like "*" to a couple of the fields, but then I hit a wall and nothing returns... I have checked and the fields are all text.

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

Thanks Rabbie- I tried tinkering with some stuff to no avail. Reinstall seems to be working now.

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

Not to steal your thunder Ken, but might this be the sort of thing you are looking for? Supply the table name and name of your index field, it returns the next number. Function GetTableIndex(GetTable As String, GetField As String) As Integer 'DATE: 04-17-08 'PURPOSE: get index number for a new...

I have done almost this exact sort of thing on a project awhile back and it worked out fine. I say almost because all of my back-ends were identical. Given potentially different table structures, I agree with TKnight... and frankly that sounds like a lot of redundant work. In my case, I...

TKnight, your idea is how I was going to approach it... but I am intrigued by the treeview concept, so I will look into that first- figure I should learn how to implement it even if I do not use for this project.

Thanks for the quick response DCrake. I must confess I am not at all familiar with using "treeview to create nodes and subnodes". My weekend starts in 20 minutes :D ,but I will start researching this Monday. Again, thank you for the pointer!

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

at first glance it looks like a mix up in your DMAX statement, instead of: lngNextID = DMax("[ID]", "Authorised_Listing") + 1 try lngNextID = DMax("[ID]", "tblPracticeEmployeeData") + 1