Search:

Type: Posts; User: Granty

Page 1 of 12 1 2 3 4

Search: Search took 0.12 seconds.

  1. MsOf10 Re: Access VBA sql Update - Too few parameters. Expected 1

    Have you tried creating a new query, switching to SQL view and then adding your SQL (the output version). You can then switch back to the query definition view and often it shows where the problem is.
  2. Replies
    10
    Views
    1,511

    Re: Validating multiple fields

    I assume this is Access? If so, here is a link to the explanation. I generally use the .value to avoid having to set the focus but there are some caveats explained in that link you need to be aware...
  3. Replies
    1
    Views
    764

    Re: How to check if Table already exists

    Its been a long time since I used it but you should be able to find your table in msysobjects and then remove it in the same sort of way as a query, but by manipulating the Tabledefs collection.
  4. Replies
    3
    Views
    847

    Re: Deduping in VBA using an ID field???

    When the LOC_ID is duplicated, are all the other fields dupicated too, or do they have different data?

    e.g. for (LOC_ID, Otherfield1, Otherfield2)

    Is it:-
    1 ,Blah, Rhubarb
    1, Blah, Rhubarb
    ...
  5. Replies
    3
    Views
    1,390

    Re: SQL Query Against Oracle Server

    Is 'account' always the same length? If not your solution might cause problems later.

    Try SUBSTR(ACCOUNT, -5) (that seems to be the general answer to this looking on the web).

    J.
  6. Re: *Beginner question* : How to write an insert sql statement

    Can you post the code as you have it now?
  7. Re: Push excel data to Access table - VB Application

    Do you _have_ to push from Excel or can you possibly pull from Access instead?
  8. Replies
    1
    Views
    507

    Re: help: create sql syntax on vb6

    I'm not really sure what you are trying to do here, could you try and explain it a bit better?
  9. Replies
    2
    Views
    753

    Re: copying from one workbook to a new one.

    Try changing:

    wb1.Sheets("NewIncident").Copy

    To:-
    wb1.Sheets("NewIncident").Range("A1:Z50000").copy

    Replace the range numbers with the actual range you want ofc :)
  10. Thread: Query in Query

    by Granty
    Replies
    3
    Views
    576

    Re: Query in Query

    Not sure what database you are using but something like...




    SELECT [Source of information], MONTH([Contact Date]), COUNT(1)
    FROM [English Students]
    GROUP BY [Source of Information],...
  11. Replies
    2
    Views
    448

    Re: Sub-query problem

    You have it backwards.

    You have it that you get a list of room-bookings which don't overlap the given times. In your example, room 1 is in that list because the 3rd record is returned by your...
  12. Re: [RESOLVED] VBA coding to export Access 2007 query results into existing Excel 200

    Isn't the 'true' parameter in your TransferSpreadsheet the HasFieldNames option?




    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, _
    "Contributors Who Donated in Past Week",...
  13. Replies
    4
    Views
    1,015

    Re: Timing VB Code

    There is also the TimeGetTime() API function which is very accurate
  14. MsOf07 Re: Pivot tables and postgres functions

    Seems I can create a simple view in the PG database that has the SQL:

    Select * from myFunction()

    and then link my pivot to that through the odbc connection. This seems to work so far....
  15. MsOf07 [RESOLVED] Pivot tables and postgres functions

    Hi all,

    In the past, I have often created Excel Pivot tables for my users that use an external data connection to get the data from SQL Server. Often, the process to create the required output...
  16. Replies
    0
    Views
    458

    MsOf03 Change source server of pivot table

    Hi all,

    I have a MI workbook in Excel 2003 that has a lot of pivot tables and graphs. However there are only 4 separate master pivot caches and the rest are just based on those.

    The data source...
  17. Re: Append data from SP to access table without DAO

    Of course I can :blush:

    I was so wrapped up in messing around with the access side I forgot all the things I could do server side....

    It's been a long day (and Im sticking to that excuse)
    ...
  18. [RESOLVED] Append data from SP to access table without DAO

    Hi clever people,

    I'm trying to return data from a SQL Server SP to a local Access database and insert it into a table. This is usually no problem but I have to pass a couple of parameters from...
  19. Replies
    3
    Views
    611

    Re: If ... AND ... then problems

    Try changing to:

    If ActiveCell.Value = TempO Or ActiveCell.Value = TempA Then....
  20. Replies
    13
    Views
    1,057

    Re: Error 438 on simple log in code

    Rename your textboxes to txtUserName and txtPassword and try that - I have a feeling UserName and Password are reserved properties.
  21. MsOf03 Re: Reference button on worksheet from module

    Thanks Westconn1 that works great!

    Would have taken me ages to find that ref path, cheers for the time-save :)

    J.
  22. MsOf03 *Resolved* Reference button on worksheet from module

    Hi all,

    quick one (hopefully).

    Unfortunately Im forced at this place to use Excel (ugh) for a bit of development.

    I have stuck a couple of buttons on a standard excel sheet (not a userform -...
  23. Re: VBA 4 strings randomly into 4 boxes

    I didnt think of doing it that way!

    Works perfectly, thanks anhn :D
  24. [RESOLVED] VBA 4 strings randomly into 4 boxes

    Hello folks,

    been a while since I coded and I'm rusty :blush:

    On an access form I have 4 boxes. From my database I have 4 strings. How to randomly put the 4 different strings in the 4 different...
  25. Thread: Insert Into

    by Granty
    Replies
    4
    Views
    357

    Re: Insert Into

    Are you just trying to add the data to the new table or are you trying to add the selected field (and all its data) into a table that doesnt yet have that field?
  26. Replies
    3
    Views
    486

    Re: Select date only?

    There are a few different ways all using either CAST or CONVERT to remove the times - CONVERT has some inbuilt "styles" for dates that should work.
    ...
  27. SQL Server 2K/2K5 - Find broken referential integrity

    Hi all :)

    I've started working in a new contract as a data integrity analyst. The system I'm working on is pretty big, and also full of really bad data.

    e.g. Lots of child records where the...
  28. Replies
    0
    Views
    413

    SQL Server 2k DTS problem

    Hi all,

    I have to import a text file into my SQL Server database via DTS. This is usually no problem, but I am getting an error "Column Delimiter not found". I looked up on MSDN and it said I...
  29. Replies
    7
    Views
    805

    Re: SQL Returns duplicate results.

    Inner joins are fine, it is far more likely to be your database structure that is the problem.
  30. Replies
    7
    Views
    805

    Re: SQL Returns duplicate results.

    If there are any duplicate values in any of the following, you will get duplicates in the result:

    tblQuote.Contact
    tblContact.Contact1
    tblCustomer.Address1
  31. Replies
    8
    Views
    555

    Re: Using Access Import Facility through VB

    I replied with a bit of info in my first post (after yours). Did you need more help?
  32. Replies
    8
    Views
    555

    Re: Using Access Import Facility through VB

    To be honest Hack, I cant even remember what I was trying to do, let alone how I did it! I've changed jobs twice since I posted this question.....

    I'll have a think and if I remember Ill update.
    ...
  33. Replies
    8
    Views
    555

    Re: Using Access Import Facility through VB

    Wow, thats one hell of a delayed reply! ;)

    What exactly are you trying to do? You should use the DTS to import a CSV and then save the package. You can edit the package from VB if you need to...
  34. Replies
    2
    Views
    476

    Re: SQL Server hardware.

    Cheers brucevde (was hoping you would see this thread) I'll read up that stuff and get back to you.

    J.
  35. Replies
    2
    Views
    476

    SQL Server hardware.

    Hi all,

    I used SQL server a lot at my last company but have now moved to a new company. Atm here all they have is access which is nowhere near large enough for what I need to do. So Ive been given...
  36. Replies
    1
    Views
    574

    Re: Changing the MS access Input mask via code

    How do you mean Input Mask on a table?

    I thought Input Masks go on textboxes....

    MyTextBox.InputMask = "(###) ###-####"
  37. Replies
    47
    Views
    5,594

    Ack! Sorry Brenda, I only just realised you are...

    Ack! Sorry Brenda, I only just realised you are using .NET which probably explained why my code on page 1 is not working :blush:
  38. Have you tried the 2nd way but without quotes...

    Have you tried the 2nd way but without quotes around the True and False?
  39. Modify in what way? And how are you presenting...

    Modify in what way? And how are you presenting the data to your user?

    If your controls are bound to the recordset then you are stuck I think. If you populate them yourself then you should be able...
  40. Replies
    12
    Views
    644

    I think the CASTs have to go on each Bit field. ...

    I think the CASTs have to go on each Bit field.

    SELECT (CAST(Electric AS Numeric) + CAST(Gas AS Numeric)....etc
Results 1 to 40 of 441
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width