Search results

Woo, it works =D Go you !!! I knew it would be something Simple Thanks for your help

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"...

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...

This worked great, you are my saviour, thanks

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...

If any of you are interested, ive managed to create an alert, every 10 seconds it checks for a new call and opens up a form and displays only the calls that have not been read, have attached a copy incase anyone else would like to see how ive done it or wish to improve it at all.

Passwords for users are their 1st names, all lowercase

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...

CJ_London Have made the changes you have suggested, will test it and see if it solves the problem, thanks

I copied this code from another database i made and was a lot more complicated, and it just ended up like this after i finished messing with it, but as you said so long as it works.

I have attach a copy of the database, had to remove all information from tables as contained sensitive information.

as far as i know square brackets are only required if the field contains a space in it, i may be wrong but the filter works fine without them

I have 2 tables tbl_Caller and tbl_Call tbl_Caller contains fields RefNum - Text - Primary Key CompanyName - Text Contact - Text Postcode - Text Comments - Memo tbl_Call contains fields ID - Autonumber - Primary key RefNum - Text Date - Date / Time Time - Date / Time Category - Text CallLog...

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...

Ive solved it now Just incase anyone has the same issue this is the code i used Dim dbDeviceLog As DAO.Database Dim rstLocation As DAO.Recordset Dim DeviceID As String Dim NewDeviceID As String Dim Location As String Set dbDeviceLog = CurrentDb Set rstLocation =...

This is the code i am using at the moment on a form containing all information from the location table Device ID, Location, SentToDepot, ReceivedFromDepot. (Last two fields both being dates) Private Sub Command19_Click() Dim DeviceID As String Dim NewDeviceID As String Dim Location...

The Devices are all named according to depot, for example Depot 1 devices might be named DP1D01, DP1D02, DP1D03 For Depot1 Device 01, 02, 03 etc And depot 2 devices might be named DP2D01, DP2D02 etc So if i take a stock device from the hub and Allocate it to a Depot i want to be able change...

Database attached

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...

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...