Search results for query: *

Hi, I haven't been using Access for a few months so I imagine what i'm asking is really basic, but I can't seem to figure it out all the same. I have a main form with a subform, and also a separate filter form. The filter form opens the main form with a filter based on the subform (maybe the...

Hi, I have some combos which are being dynamically added to the page (i.e. multiple dependent combos) and I never know how many might be on the page. All is working fine, except I need to get the actual text of each selected option, for each combo that exists on the page. I'm almost there - I...

Hi, I have a subform (frmSubFiles) with some code which does a recordcount and updates a txtbox on the parent form (frmIFLR). Private Sub Form_Current() Dim intIFLRid As Long If Not IsNull(Forms!frmIFLR.IFLRid) Then intIFLRid = Forms!frmIFLR.IFLRid Else...

Hi, I know how easy it is to open another instance of the current form, but... I have a subform on my form, which in it's OnOpen event fires some code to update a textbox on the parent form (recordcount). How do I code so the OnOpen code in the subform knows which instance of the parent form...

Hi, I need to return only those records where the contents of field1 is contained in field2. Eg. Field1 1234 Field2 \\svr\share\folder\1234.pdf It'll be something like: SELECT * FROM tblMyTable WHERE Field2 Like *Field1* But this doesn't work. Any ideas anyone? Thanks, Burns

Hi, A bit of an urgent one unfortunately... 10 days ago I released a new version of a frontend DB, and forgot to update the linked-table links. The copy of the backend DB I was using for development was very much out of date. This means that an out of date copy of the DB has been receiving...

Hi, I have a main form, with a subform. There is only one field on the subform. When you add a new record, I need to make the field in the subform mandatory. I.e. when I add a new main record, I want the user to have to enter something in the field in the subform. Seems like this should be...

Hi, I'm doing a lot of work currently with converting databases from 97 to 2k, but I also have to work with 97 databases without converting them. Obviously you can set which version a .mdb is opened with, but I was hoping to set this to 2000 and add Access 97 to the Send To menu. I created a...

Hi, tblTopics (simplified) ---------- TopicID autonum MainGroup text(50) InReview Yes/No Completed Yes/No Weighting Integer I need to have a report which will display 3 columns: distinct MainGroup Sum(Weighting) WHERE InReview=True Sum(Weighting) WHERE Completed=True Is this...

Hi, Have a feelin i'm being a bit thick 2day, as this seems like it should be easy... Given the following table (simplified): tblTopics ----------- TopicId Autonum (key) MainGroup Text(50) InReview Yes/No Completed Yes/No Weighting Integer(single) I need a...

Hi, I've got a report which is returning some duplicate rows (total of 29), even though it's underlying query is only returning 23, non-duplicated rows. I have no idea why this is - I have no code worth talking about in the report. I have a custom ordering function called in the query, but...

Hi, I'm being brought in on a project very shortly, and all I know is the following: * There are 2 identical Access 97 (soon to be 2000) DBs. * Two departments hold info in these relating to hard-copy files that they are in charge of updating. * The hard-copy files have moved to the other...

Hi, In a form this would be easy for me, but i've not done very much report coding so would really appreciate some help on this. My report has, for each record, 4 rows of fields in 3 columns. I.e. sort of like a grid containing 12 cells. Each row consists of a Date/Time, a checkbox and a text...

Hi, If I use client side JS to modify my page, and I want to know what the source is (for debugging etc) at any one time, is there any way I can view this? View Source only returns the document as it was initially sent, as far as i'm aware. Suppose I could write a script to display it, but...

Hi, Can I read in a very simple XML file, query it like it's a relational DB and work with it in ASP like it's an ADODB recordset? ANY pointers would be really appreciated as i'm struggling to find anything on this which is at my level (i.e. very much an XML beginner). Thanks, Burns

Hi, I'm trying to compact a DB, in which I have a table ADMINConnectedUsers which tells me who is using the FE Access app to connect to the backend DB. Both are Access 97. When someone opens the FE app, their NT login ID is put in a new record with a timestamp. There is an Autonumber key field...

Hi, I've got the following VB6 code which calls a DLL and returns an ADODB.Recordset. I need to get it to work in an Access 97 DB but can't figure out what I have to do. Private Sub cmdGetuserInfo_Click() Dim CCPM As CCPnMObjects.CCPnM Dim rs As ADODB.Recordset Dim NTUserID As String 'On...

Hi, I know it's possible to create a query, and in the sort order clause call a Function or procedure to sort the records in a custom manner, but i'm unsure of the best way to code this proc. I've got file numbers like: A1.1 A1.10 A1.11 A1.12 A1.17 A1.2 etc. Obviously this isn't the correct...

Hi, I just worked on a DB that I look after yesterday. All I did was to attach the tables by using code (some linked, some imported) using UNC path's rather than a locally mapped drive letter (i.e previously done thru the Link Tables dialogs). Now i've found that only one person can use the...

Hi, A simple qs here I hope, but one I've never really put much thought or research into. If I only want to use a lookup table to, say, lookup a Country from a list, should I include an Autonumber field along with the country column (assuming there's no other columns/fields such as Currency)...