Search results

Hi Gang! Been a while. I have a group here in my office who are writing a A'2000 FE and they want to link it to a A-97 BE but I'm a little unsure if this will work or not...? Anyone have any experience with this? If there a compatibility issue I should be aware of? Any known problems...

I think Access may become Microsofts Red-Headed Step Child (sorry if offended any red-headed step childern posters! ;) ) I just went to a MS conf yesterday on ASP.NET v2 new features and the guest speaker did a 1 hour demo on MS InfoPath 2003 at the beginning of the seminar and all I can say...

Heres a new one - Been working all morning on a new form - everything has been working great but... NOW... all of a sudded I get an error message when I try to open the form telling me that the "The On Open Event you entered in the event property setting produced the following error: Arguement...

OK - First I realize this is in the wrong forum but this posts is kind of a request for help / mini-rant about developing schema in Access then upsizing to larger RDBMS so I thought I'd post it here as this forum tends to get more traffic then the SQL Server forum and it could possibly help out...

Hi All - We are preparing to start testing a new Citrix environment and I am hoping some here may already be developing in that environment so my question to you good people is: I have multiple MS Access 2002 FE/SQL Server 2000 BE's currently in production that are candidates for this...

I am banging my head on this one - need some help badly! I have some code that I am using to create a unique ID based on two parameters (UNITID and FEATURE_TYPE). I am using a query that parses a field to get the first character and then looks at two variables to see how what the value should...

Hi Gang - got an issue here and I think I'm having problems seeing the forest through the trees so I hope one of you good people can help me out! I have created an ADO recordset that returns 1 record. I want to grab that value and add it to a variable but I can't seem to remember how to...

Parse String Help Needed! Hi All - in a bit of a bind on this one so I could use a bit of help here! I have an ID field in a db that is a combination of numeric and text put together. An example of what this looks like is this: Letter P or L "-" Number "-" Number so... this ID could range...

Hi All - Need some help here as I've hit the proverbial wall on this one... First - I know this is VBScript I'm look for help on in an Access Forum but I know some of you here work in multiple languages so I thought I'd post to see if someone can assist me. Basically what I am trying to do...

I was gonna put this in the moderators forum but I wasn't sure of the "visibility" of that forum and I wanted to get some feedback from other members so I'll post it here and if Jon/Mile want to move it with a link to it from here that would be swell :) My Question: Would it be possible, or...

Hey Gang - need some help... I am working on setting up a form that will allow "power users" in one of my applications to create their own queries "on-the-fly" by selecting tables and subsequent fields from two listboxes. I am having issues building the criteria for my "fields" listbox as the...

Hello All - I am in the process of building a form for an application that will allow the users the ability to create their own queries. The form will have a list box showing all available tables. When a user selects 1 or more tables the field(s) for each table will be shown in another list...

Change form within a form with a twist! Hey Everybody, Got a design question thats been buggin me for a while and I'm hoping maybe someone here can help. I have a form (frmTOC) that is the master navigation form for a db I'm developing. The form consists of a large Treeview control and a few...

I have a sime form/subform set up and in the On_Click event on a button on my main form I am trying to append a new records to a subform, requery the subform and then set focus to the new record in the subform. Everything works well except for the set focus part as I can only get it to set...

Hi All - I am trying to use a query with a where clause as the source for a recordset and I keep getting this funky error: Error -2147217904 (No value given for one or more required parameters) The strange part of this is that if I copy/paste the exact same SQL into the query designer and...

Hi Everyone - I wanted to get some of the experts on this forums opinion on what is the best way to code. Is it better to store code in the object module or is it better/ more effecient to store the code in a common module and call the code to the object as needed? I have heard differing...

Hi All, I've been asked to update an old word doc system with a database and I haven't ever worked with disconnected db's before so I thought I would post this topic here and see what you all feel would be the best method to achieve the desired result. Basically, The system used to work by...

Hi Folks - Does anyone have any familiarity with putting combo boxes in treeview controls...? Can this be done in Access (I know it can be done in VB) I was playing around with an ActiveX Control (Microsoft ImageComboBox Control 6.0) That seems to be something like this but I don't have any...

Hi All - I am trying to implement a TreeView control in my form and its not working for me. I have found a few examples of this control and I am trying to adapt the code to my db with little success and I'n not sure of the reason why as it seems pretty straight forward. I keep getting error...

Use recordset as form recordsource... with a twist Hi Everybody :D I've racked my brains on this for a few days off and on now so I'm turning to the forum of saviors for some much needed assistance... I have a Client/Server app that I'm attempting to development using only ADO and parameter...