Search results

  1. dgoulston

    query causing problem with dates

    ok i have a query with 2 fields, Endtime: AccountTime Starttime both date input from another query, if i run without any criteria it works and get some results: Endtime Starttime 9/6/2005 6:24:09 AM 9/6/2005 6:23:53 AM 9/6/2005 6:24:16 AM 9/6/2005 6:21:20 AM 9/6/2005...
  2. dgoulston

    database location

    all i need to do is find the database location eg: c:\myfolder\mydb.mdb kind regards Dal :confused:
  3. dgoulston

    Search using page's...

    i need to have a web page that accesses my database, i have created a page (in access 2000) but i need to set up a text box with code behind it which someone can enter some data in it and it finds the record. if u need more information i can provide it. thanks DAL
  4. dgoulston

    table location?

    table location? (solved!) im sure this is a simple task but i cant figure it out all i want to do is find the database location eg. c:\myfolder\mydatabase.mdb where a linked table is being accessed from... and i need to do it in code and put the answer into a varible... i can get the...
  5. dgoulston

    stupid access.....??

    ok here is my code, when it gets to the Set ws = DBEngine.Workspaces(0) line it says "could not use c:\db.mdb, file allready open" but of course its open,,, its the database this code is being run from, but i never had this come up before, and even if i comment out that line i get the...
  6. dgoulston

    exclusive access

    hellllllllllllllllllllllllllllllllllllllllllllllp ok i have been working on my database for a long time now and never had this problem, i open it up and try and edit something and it comes up with the message: "you do not have exclusive access to the database at this time, if you preceed to...
  7. dgoulston

    create a table

    anyone got a clue whats wrong with this code below? ---------------------------------------------------------------------------- Private Sub Command5_Click() Dim tablename As String Dim sourcedb As String Dim db As Database Dim tdf As TableDef Set ws = DBEngine.Workspaces(0) Set db =...
  8. dgoulston

    adding records

    hay ok here is the problem ############################# If bit(0) Then With rst .Edit ![0] = "X" .Update End With End If ########################## and i do this for bit(0) through to bit(20), the colomn names are o...
  9. dgoulston

    Dll (urgent Plz)

    ok i am trying to use a dll to decrypt some data. this is what i have soo far: Option Compare Database Declare Function DesConfigure Lib "c:\#\dndes.dll" ( EncrFlag As Integer, ChainType As Integer) Declare Function DesDecrypt Lib "c:\#\dndes.dll" (ByVal InputBuf As String, ByVal OutputBuf...
  10. dgoulston

    check if query returns empty.

    is it possible on a form to put some code that when a button is pressed it runs a query and then checks if the query returns anything, because the query accepts 3 like/between statements and 1 is a date which the user enters and if that date isnt in the database the query will not return...
  11. dgoulston

    report layout

    ok i have a report, i have included a screen dump of it basically the details layout is as below: ############################ page header ############################ ______________________.......______________________...
  12. dgoulston

    date in text box?

    i have a table which has lots of fields but the only one im interested in is the date, (fieldname = date) i have a form on this for i want to display the first date and the last, the dates are not in order, so i have a query that works out what the earliest and latest dates are e.g. date...
  13. dgoulston

    code for cutting strings

    all i want to do is seperate a string into bits of 4 characters. eg. dim stringa as string dim bita as string stringa = "231832738127312" while (stringa length) > 0 then copy first 4 chars of stringa into bita delete first 4 chars of stringa write bita to table (i know how to do that...
  14. dgoulston

    questions?

    is it possible to turn off the questions it asks when it runs a delete query or append query. because i know its possible to turn it off in access, but i want to turn it off in the query its self as when i distribute the database i want the person to be able to run the query without having the...
  15. dgoulston

    graph problem...

    ok the first one i think may be easy, 1, i have a graph based on a range of about 300+- times of the day ranging the full 24hrs, i access them straight from a table and it has times along the botton and users (online at the time) up the side. the graph works fine all except if there is no...
  16. dgoulston

    pause?

    dustartdate.SetFocus dateinuse = dustartdate.text ducalcdate.Caption = dateinuse + "*" stDocName = "deletetb2" DoCmd.OpenQuery stDocName, acNormal, acEdit stDocName = "dayusagecalc" DoCmd.OpenQuery stDocName, acNormal, acEdit '-----------------------pause...
  17. dgoulston

    link database

    is it possible to link a table to my database from another computer which is on the network, i want to use the ip address of the other computer to access the database is this possible
  18. dgoulston

    graph labels

    i have a graph which the bottom scale is in minutes but i want the lables just to show the hours is this possible e.g. its a bar chart so there would be say 100 bars but only 10 lables.... is this possible... thank you in advance DAL
  19. dgoulston

    im stuck///////

    help ok heres the prob, i have a log on date and an log off date most calls range from 1 min to 1hr duration i want to make a graph that shows users/time so that the bottom axis is in minutes and shows at each minute how many users were online.. ..................... ok wat i want is...
  20. dgoulston

    calculation..?

    help ok heres the prob, i have a log on date and an log off date most calls range from 1 min to 1hr duration i want to make a graph that shows users/time so that the bottom axis is in minutes and shows at each minute how many users were online.. i am baffeled on how to go about doin...
Top Bottom