Search results

  1. N

    Problem with Between 2 dates VBA

    Hi, Im trying to use VBA to create a filter by date range. the user inputs 2 dates and the database filters all records by dates in between the 2 dates, Code below Dim var_CustDate1 As String Dim var_CustDate2 As String var_CustDate1 = InputBox("Please enter start date in format DD/MM/YYYY"...
  2. N

    Problem Running batch file from Shell function

    Hi guys, im trying to run a batch file using the shell function but i have come across a problem, the batch file uses a program called cecopy.exe which copies files from a windows mobile device that is currently connected via active sync, this works fine when used as a batch file on its own...
  3. N

    Exit current subroutine from called function

    Hi, is there a was of calling a function at the start of a sub that will allow you to exit the sub from the function, so if i were to have a database that requires logging in so when the form loads it uses the function CheckCurrentUser to see if the user has loged in, if not then it will make...
  4. N

    User alerts for Call log Database

    Hi Guys, I have a call log database that is used to log calls (Obviously), i have serveal users over a network and everything works great, but i have been asked to create an alert function that notifies the user when a new call is logged assigned to them by a different user, similar to outlook...
  5. N

    Form only saving half of information

    I have a call log database to record calls i make and recieve, the form in question cantains info from two tables tbl_Caller and tbl_Call, tbl_Caller containing all the caller information eg company name, contact name etc. and tbl_Call containing the time and date of the call and what was said...
  6. N

    Edit Multiple Tables from 1 form

    I have this database, i use it to keep track of the location each device is at. I want to be able to rename a device at certain locations so i would have to rename the device in tbl_devices, and would have to put todate date in the ReceivedDateFromDepot field in tbl_Location for the old name and...
  7. N

    Filter Form from Multiple fields in a ListBox

    Hi I am about to throw my computer out the window. I have a list box called SearchResults containing several fields including DeviceID and ReceivedDate. I want to be able to open and filter a form from this list box from these two fields. I have it working to a degree using this code behind a...
Back
Top Bottom