Search results

All, I'm having great difficulty working out the syntax to change the Recordset on a Subform. I'll try my best to explain. I have a 'Menu' subform which gets it's recordset from an ADO recordset, it's a continuous form using a Textbox for he list of options. The problem I'm having is, I'm...

All, It is possible and how can I, append the result of a recordset to a table. I have a text file which is 60mb (weekly files) and for this particular system I only need about 25% of the records and 45% of the fields (the file has 73 fields!!!) I figured I could query out the information and...

All, Is there a way that I can ask if a Table is Linked or Resident in a Database. I would like to use the follow code without Defining which table not to include? Public Sub LinkTables(strP As String) Dim vItem As Variant Dim strTable As String For Each vItem In CurrentDb.TableDefs If...

All, I have search facility within my DB, the problem is I am returning the results to a TEMP table on the Client in order to buffer the data and wherever possible not create to much traffic to the BE. Here is the code I have: Public Sub SearchRecord() Dim db As DAO.Database...

All, I try to use common naming conventions wherever possible. Every now and then I come across what should be common but I can't find a standard method to use. It not really a huge problem, but as this is the General forum I thought I'd ask. Does anyone have a good link with a long list of...

All, I have the following code to insert records into temporary tables on the client. DoCmd.RunSQL "DELETE * FROM tblTEMPNTCChild;" strSQL = "" strSQL = "SELECT tblNTCChild.NTCChildID, " strSQL = strSQL & "[1stForename], " strSQL = strSQL & "[2ndForename], " strSQL = strSQL & "Surname, "...

All, Bottom line I'm in bit of a pickle, work has moved forward the migration of Office97/NT4 to Office2003/XP by 2 months (clever lot) and was hoping not have to cram for this question until at least 3-5 weeks. I'm looking for pointers/suggestions because I now have to test in Access2003...

All, Introduction (I case I'm doing this all wrong) I have 1 huge table of data: SysID PersonData " " " " AddressData " " " " " " " " " TelephoneData " " " " Year (this is 1 or 2) I'm taking each component Person, Address, Telephone info and making a compacted table of each (i.e. lots of...

All, Sorry for the vague title compared to the problem I have. I am automating a process where the user Imports a CSV file abd then runs several queries abd deleting the Imported file. What I would like is the equivalent of Excel's GetOpenFileName dialogue box. In essence, I would like the...

All, This may a little difficult to explain but hopfully the attached DB will help. I am re-designing my database and I'm at an stop the process to change the data stucture. I originally had: Main Employee Table EmployeeID - PK/Autonumber GivenName - Text Surname - Text StartDate - Date...

All, Does anyone know how to Import a Dynamic Named Range from Excel. I have (well...ok...they have) workbooks, each one has a Named range 'MyTable'. Which is something like =OFFSET($A$2,0,0,COUNTA(A:A)-1,19) Access doesn't see this type of Named Range. I wish to loop through each...

All, OK, I'll give this a go and if I leave anything out please post back with questions. I've been putting this on hold for oooo 8 months. The basics are that I need to calculate Employee holidays based on LOTS of factors. Here are the key elements: tbl_EmployeeMain 1) StartDate - the date...

All, Can someone please show me a nicer way to achieve the following: If IsNull([frm_UTC1_Subform]![TCUser]) Then [frm_UTC1_Subform]![EmployeePid] = Null Else [frm_UTC1_Subform]![EmployeePid] = SystoPid([frm_UTC1_Subform]![TCUser]) End If If IsNull([frm_UTC2_Subform]![TCUser]) Then...

All, I'm trying to get the correct syntax to Validate a Textbox. I'm trying to use BeforeUpdate bet can't figure out the how. Rules: Person must enter a Date: >=#09-11-04# and <=Date() The problem I have is that I need to run some code to update 3 other Fields on the form, If the above is...

All, I have a Main Form where the user enters a value in a Textbox and then hits a Button to return the data. I have recently found out that there may be 2 or more records with the same Value in that field. So now I have introduced a method to open a Form with any examples where there are more...

All, When I open an Excel Workbook from Access, and then close done Excel, excel.exe is still in memory, I assume this because the Sub that called is still somehow linked, when I close Access excel.exe closes. How do i stop this? Thanks.

All, I have been banging my head against a brick wall over this, I sometimes get given Access VBA code to look at when other get a little stuck. I'm by no means an expert, the reason is that the code they usually find problems with is manipulating Excel objects and that where I come. BUT, I...

All, Not really an Access question, BUT thought someone may have an idea as it's related to querying other data sources. I'm trying to return data using the ODBCDirect method from an Oracle Database, So far I have: Private Sub ODBCDirectTest() Dim wrkEG As Workspace Dim cnnEG As...

Hello All, Does anyone know how to have the mouse pointer remain a normal Arrow when the mouse is passed over a Textbox? Regards,

Hello all, Heres the deal, I have 112 Text Boxes on a form. Each one is Link to a Macro via an On-Click Event which all work lovely. Now I'd like to add extra features to the form/application. 1. I'd like a drop down menu when the user Right-Clicks on any of the Textboxes. This needs at least...