Search results

I have a table in Access that is as follows: I need the Whose field to become like the MS-Access. Can this be done using the Access to Dataverse tools?

Hi Guys, Some Background: I've got a front-end and back-end db -- the communication is extremely poor between them but that can't be changed! Therefore I've gone from the db to several Arrays for most of UI. There is one giant outburst of db activity at the outset of the front-end and then...

Is there a way to add the previous row's cell "B" value to the current "B" cell and then add the current row "A" value? Kind of like in Excel? Thanks, Marty An Example: A B (Starting Point = 0) 35 35 = 0 + 35 15 50 = 35 + 15 4 54 = 50 + 4

I have info in Excel about people staying in camp. I've show a sample of one person in the following: How do I convey info to a Table in Access that is normalized in the easiest manner using VBA? There must be some "standard" way -- I can't be the only person thats come across this pattern!!

I have a Problem that occurs between the time that a form opens ( no problem with the on open command) but before it actually loads (the on load command in which I place an "open argument" - bytBufferCurrent ). I consistently asks me for a parameter value - tblParticipant.ParticipantID - (this...

Hi all, I have button on my form which does the following: Private Sub cmdPrintRollCall_Click() On Error GoTo Err_cmdPrintRollCall_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "rptRollCall1stXR-12" stLinkCriteria = "TDate = " & Me.dteDate 'the date on the Form...

I got the "Error #3326 - Recordset Not Updateable” but there seems to be no reason. Where do I go next? - I'm looking for suggestions! Summary tried the app as a user on 2 different PCs in the office... one works OK although there are some long duration issues and 1 does not - got error "3326"...

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

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

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

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

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

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

Hi Guys, I have racked my brain over this :banghead: !! Probably something very simple:o I want to run an update query on a table called "tblPMT_15". The update will be from a query called "[qry6_1_3_Latest]". Fig 1. shows the problem. Those things which remain constant are the [Question ID]...

Hi there, Is there a programmatic (VBA) equivalent to: double-clicking at the top of a column when the entire work sheet is selected, making all of the columns automatically change to perfect column width? Been looking for a couple of hours!! :banghead: Regards, Marty H.

I am entering huge amount of data (which was finally normalized) with SQL commands. In this 1:M schema, the first “insert” is simple, but the next INSERT requires that I get the foreign key from the first INSERT. What is the simplest way to do this? TIA

Hi Guys, May I have some advice -- I have one attribute in the table and the table is normalized. But we have the same attribute in two different forms, one with a table lookup and the other with a free form text input. I'm trying to rationalize this for a dashboard output. Do I keep it as...

Here is the import statement I'm using: DoCmd.TransferText acImportDelim, "IT315 Import Specification_txt", _ "IT315", "D:\4533 Hires Rehire Status Change\IT315.txt" I can manually transfer the data ie thru File --> Get External Data etc but I can't seem to get the above...

Hi, Two years ago I released a an Access 2003 program to my client. Now they want to upgrade to 2007. I got everything working in 2007 except this little bit of code: DoCmd.RunCommand (acCmdPrintPreview) It gives me the vague answer that "The command or action "PrintPreview" is not available...