Search results for query: *

Hi all, Hope someone can offer a suggestion with this one. I have been tasked with designing a database from a paper-based form. However, the paper-form has not been designed with databases in mind. Specifically, I have one question on the form as follows: Tick all that apply (then lists 15...

Hi Folks, I have the following query: SELECT First([APCGeneral].[PATID]) AS [PATID Field], First([APCGeneral].[SPELLNO]) AS [SPELLNO Field], First([APCGeneral].[CONSEPNO]) AS [CONSEPNO Field], First([APCGeneral].[STARTDT]) AS [STARTDT Field], Count([APCGeneral].[PATID]) AS NumberOfDups FROM...

Hi All, My situation is thus: I have a SQL2K database that I need to access from Access2K. Now I know I could setup lots of linked tables using ODBC, but it is essential that 2-way access to the SQL2K database is not in effect. I was thinking of designing a macro that would first make a copy...

Hi all, I would welcome any and all suggestions on the following topic. I have been commissioned to design a Data Warehouse from scratch for our organisation. The particulars of the project are as follows; 1) Annual amount of data approx. 2.5Gb 2) Potentially 50-100 end users 3) Requirement...

Hi All, I am trying to get the following DLookup function to work, but it's not happy: I have a form (MAIN), based on the table (COMMISSIONING). The form contains a simple lookup to a field (GPCODE) in a second table (GENERALPRACTITIONERS). I would like my DLookup control to return a text...

Hi everyone, Can someone tell me how to the following with VBA (I know how to do it in SQL!!!). Private Sub Form_Current() ' If value in GPLookup text box is not a Sandwell PCT ' display value in GPLookup in red and display FinLiability label. If...