Search results

Thank-you arnelgp!!

Hi Guys, When the data is copied to the DB via a list box from an "external source" by using ctrl-C/V, how would I count the number of pieces of data that were imported to the db? In the example, there are only 3 pieces of data, but in reality 300-400 are sometimes transferred. The amount...

Everyone: Thanks for answering so quickly... Gasman: BRILLIANT ... I can't believe how long I was looking at this .... and for the Second time Thanks to all!

Hi, I have followed the Access Cookbook by Ken Getz et al. number 2.11 "Open Multiple Instances of a Form" for recreating my forms and the following code is what I came up with: Public Sub acbAddForm(sCriteria As String, sCaption As String) 'Two major changes: 1) sCriteria, and 2)sCaption...

I am currently working for the Canadian Armed Forces, on an Access db that has over 1.2 million items with over 2.2 million instances of the items (a 1 to many relationship), as well other information. It currently requires less than 1.2 G of storage. I have redesigned the previous database...

OK... Code that opens the query Just the combo box that opens the query and then after the update of the box comes: Private Sub cboSystem_AfterUpdate() Me.Requery Me.Section(acDetail).Visible = True 'Me.Detail.Visible = True End Sub SQL for query that has no problem (this is the summary...

Mark_, Colin I have the parent form open thru out ... However, I think I might have found a clue... the Query is based upon an IN (SELECT ... statement) which is actually requesting the parameter ... not the query itself. The SetParameter command requires that the method must process the...

Colin, I thought I solved my problem by using DoCmd.SetParameter but now I seem to have another: Run-time error '2766': The object doesn't contain the Automation object 'LLAD.' The 'LLAD.' refers to the system (all except the period at the end)... Am I on the right track ... sorry I can't...

Hi all, I've got a query with a parameter in a subform and everything is alright. I get the parameter [cboSystem] from the response I make to a combo box. I don't know if this makes a difference but the form I'm dealing with is not bound. However once I try to make a query based on the same...

Hi, I have recently come across a product called MarkLogic, a nosql database. They give the developer copy away and charge many $$$ for the production copy. It can only communicate via an HTTP:// request. I'm not sure how to set it up but I believe that VBA is capable of doing that. Are there...

It version 14.0.7165.5 (32 bit) with the latest version Windows 7 Did you have the memo length items in the first 25-30 rows? While this is good if you have control over what comes in, in Excel, I do not have the same control. I bet if you placed the Memo length items over 30 rows from the...

Hi, I have a problem when importing excel when the cell is longer than 255 char. The cells are 300-1000 chars long. (Verified by doing a len().) The problem is that when it is imported into Access --> appended to the table it is truncated at 255 char even though it is a memo field that it is...

Yes of course you dummy!!

Does the secondary file have to open? i.e. Forms!fQuestions_Trial_2.Form

No it still seems to give me the same error as before, but stops on: it seems to have something to do with turning the "Design Mode" on and off in the VBA screen. I'm investigating ...

I misspoke ---> there is only 1 event : Load the other event is on a button called "Close" and never really in the "On Close" event of the form.

Hi all, I am using MS Access 2010. I am trying to create a form that will change the captions in another form. See Fig 1. There are only 2 procedures: Load and Close 1) Q1.1.1 is the command button with the correct caption put in to place. (cmdQ1) 2) The [Caption] row is the caption that I...

They look ok -- just that the "Project Objective" is still equal to null --- Could this have anything to do with the fact that Response is a memo field? In fact that is why I am asking --- I've compared this to similar queries that I've done before -- successfully! Could not find a reason...

No I'm afraid not! --- Wait maybe I am checking right now!! ----> No!!!

Hi all, I can't seem to get this update query to work! The query is in Fig 1, while the subquery is in Fig 2 -- a list of Question Numbers against the Project Objective. The idea is (was) to update the Project Objective based on the Question Number. The question Number is unique -- I checked...