Search results

I need to convert an Access database to an SQL server database some time soon. However the Access db contains some queries that call vba functions. Does anyone know whether this will cause problems? I know that SQL server can call so-called UDFs (User Defined Functions) but can it handled...

I have been using access 2000 pivot tables to retrieve relatively straightforward m by n tables with a count in the body. These are simple to define (drag row and/or column variable and various relevant filters appropriately and then drag the data field, which automatically chooses sum or...

I have been using access 2000 pivot tables to retrieve relatively straightforward m by n tables with a count in the body. These are simple to define (drag row and/or column variable and various relevant filters appropriately and then drag the data field, which automatically chooses sum or...

I need to add a column to a sorted query which effectively numbers from 1 to N. It is intended as a ranking field for later statistical analysis. I can do this manually by saving the query as a table, then introducing a new autonumber field. However, I need to do this automatically, as this is...

Hi ..... I am creating a simple two field table from another table via the following code: SELECT LU_CESNdx_ICD10.CES_Index AS cesdi, LU_CESNdx_ICD10.[ICD10 Code] AS icd10 FROM LU_CESNdx_ICD10; However, I need to add an initial new primary key field called ID that is autonumbered. Can anyone...

Can anyone help with the following ... which generates a syntax error when run in VBA: Private Sub CopyTableStructure_Click() Dim MSS0 As String 'set up MySQLString to create new tables with structure ONLY MSS0 = "CREATE TABLE LU_WMCHDL_Inf_v2 AS SELECT * FROM" MSS0...

I have an update query (see attached jpg), but it is not updating. I am running Office 2000 on Windows XP. Any ideas on where the error is?

I have an Access table (tblSessions) which needs to be updated from a set of transaction records (retrieved from an Excel doc). tblSessions has fields: SessionRef (AutoNumber, Key), JobRef (Number), SessDate (Date/Time), SessionText (Text), SessionLink (Text, but also unique), Issue (Yes/No)...

I need to use dlookup in a query to populate a new field "number" with values obtained using a current field "letter". I have a (lookup) table as follows: Col1 = A, B, C, D and Col2 = 1, 2, 3, 4 which of course gives the number code corresponding to each letter. In Excel, I simply use the...

Can I use a query in Database A as a look-up table in Database B. When I try File / Get External Data / Link Tables (in Database B), it only gives me a choice of Tables from Database A. Do I need to generate beforehand a physical Table using a MakeTable Query? Any help or advice would be...

I need to dimension variables and define string constants which will be relevant to all forms in a particular project. Can someone tell me where I put these? Thank you (in anticipation)

Code to put text string into a Word document? I need some code to place a text string into (the first line of) a Word document. The problem is, I don't want to see the document at all ... just put the string value into it. Can anyone help?

... why oh why is it so difficult! I have tried lots of different combinations and I am currently tearing my hair out with frustration. My button is butBackCtlPnl03; my subform is frmSessions; the control is Sessions and my current code (on main Form Load) is...

I have a form field which displays the date in medium date format - thus 6/2/2005 (UK style) for the 6th Jan 2005. I need to format it with an added short day of week at the beginning - thus Wed 6/2/2005. :confused: Can anyone help? Thanks.

Can anyone give me code for selecting a document (Doc1.doc say), copying it and then renaming the copy (Doc2.doc say). The document will have a known path on my C drive. Thanks.

I am trying to address a subform field. If I address the subform as a separate form, the following code works OK DoCmd.OpenForm frmSessions, , , "Issue = true" :) However, once I try to access it as a subform, I get a bit lost. The main form is frmJobSess, the control that holds the...

I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :( What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record. I have Tables A and B in a 1-to-many relationship and I need to be...

I have a problem that is probably very straightforward to you Access experts. A brief description of the salient parts of my setup are given as numbered paras below. 1... I have 2 tables: Jobs and Sessions in a defined 1 to many relationship. 2... I have defined a form in parent-child...

This two minor points of code have given me a headache recently :mad: and I thought I would pass this tip on. When using FollowHyperlink code, the address (whether Internet or own computer doc) should be absolutely literal. Thus: "http:\\www.website.com" and NOT "www.website.com"...