in my c# application, I am storing to to an access 2003 Database (.mdb)
The strange things is that I started developing the application in April and all the April dates are showing as being correctly formatted to UK format.
however since start of May 2016, All the May Dates are reverting to US format and showing as March Dates in the application.
I am not sure if I have changed something in hind sight. nevertheless,...
tasawer
Last Activity: May 7 '16, 03:07 PM
Joined: Aug 26 '09
Location:
-
I required named pipe connection to connect wamp server and VB.NET
I have a desktop VB.net Application that successfully connects to SQL server both from the server and workstations.
One aspect of the application is to update data from MySQL server.
I have successfully setup WAMP SERVER on port 80 to be accessed by workstations using the server IP address in the browser; like this
(SQL Server and WAMP Server are on the same PC)Code:http://192.168.1.180
the app.config... -
How can I pass Date-Range to crystal reports in vb.net
I have created Crystal Report to display data between two dates.
From a vb Form, I need to pass the m_minDate and m_maxDate as the date range to Parameter 'MyDateRange'. I am struggling to know how to do this.
I have tried to search on ParameterRnageV alues, but struggling to understand.
For another report, I can pass single values with the code:
...Code:Dim rptViewer As New rptNamazTime
-
Crystal Reports: All Records Not Showing
Hi,
with Crystal Reports Database Expert, I have selected a single table to display records.
What I find is that not all records are showing.
I can see all the records in Form View.
I can see all the records in the back end database (SQL SERVER MANAGEMENT STUDIO)
There are no joins as it is only a single table.
What I did notice was that only the first 1000 records were there,... -
Problem with setting up time delay in a For-Next loop
I am encountering difficulty in setting up a time delay in my speed reader software.
Basically, the user will load a text file and the software will take each word into an array.
on pressing the start button, the words will be displayed one at a time at a rate defined by the reading speed suited to the reader.
using the debugging techniques, (breakpoint / F10), but Without any of the delay code, system works... -
Thank You Twinnyfo. This has worked a treat. -
Automated Backup of Database Backs up Linked Tables
Hi,
with the code below, I was successfully backing up my database regularly until I separated the Front end and used linked tables. Now only the linked tables are being backed up. (Not much good)!
how can I reference my BackEnd Tables Database 'acc.mdb' and create an automated copy.
...Code:Private Sub BackupData() Dim sFile As String Dim objectDB As DAO.Database -
Perfect... after my own solution, I thought I was the king :)Leave a comment:
-
I am absolutely certain on how I resolved it.
it was tough though(for me).
I went through a range of eight sequential dates and monitored the output and changed the code accordingly.
As time is also stored with the date, it was causing some of the dates not to be returned.
I resolved that by converting datetime to date only and then comparing.
...Code:OR (Convert(Date, PHD.FromDate) = CONVERT(Date,
Leave a comment:
-
Thanks for your suggestions.
I finally resolved it with the code below.
It works a treat.
Code:WHERE (PHD.FromDate <= CONVERT(Date, '17/04/2014' , 103) AND PHD.ToDate>=CONVERT(Date, '17/04/2014' , 103)) OR (Convert(Date, PHD.FromDate) = CONVERT(Date, '17/04/2014' , 103))
Leave a comment:
-
These suggestions also fail.
currently we are checking for both dates in one query.
My instincts tell me that I need to run a query on FROMDATE first and then Requery the TODATE
So I would need a Select statement within the where. but not sure how.Leave a comment:
-
Thanks for the reply.
Your code not work for me. However, I changed it to
Where it found the example date, but other dates went missing.Code:Convert(DATE,PHD.FromDate) >= Convert(DateTime, '09/04/2014' ,103) AND Convert(DATE,PHD.ToDate) <= Convert(DateTime, '10/04/2014' ,103)
Below is my full range of dates for one record. I need to be able to search for any date.
Please advise...Leave a comment:
-
You may use an inputbox
e.g.
hop this helpsCode:Dim sName As String = InputBox("Enter your name") MsgBox(sName) Dim xx As Decimal = InputBox("What is your age") MsgBox(xx)Leave a comment:
-
Query not returning record when searching range of dates
Hi,
in my SQl database, I have a WHERE statement to search a record based on two dates.
using the code below, Query will not return a record if SearchDate=From Date.
Amongst my records, an example date range in database is:
Search fails for 10/04/14.Code:FromDate = 2014-04-10 17:32:55.000 ToDate= 2014-04-16 17:32:55.000
Other dates (11/04/14, 12/04/14 etc) will be returned.
... -
ComboBox refuses to display blank on setting selectedindex=-1
Hi,
I am Designing a Vehicle Parts Database.
I have a first combobox 'cboVehiclemake ' that displays list of all Vehicles. The second combobox 'cboVehicleMode l' relies on the first cbo display all the related models.
when I clear all fields to add new data, second combo refuses to blank out. I am not sure why.
There are other controls and combos that behave as desired.
I have filtered and... -
after reresh, The dataentry subform should go to blank, ready to take more records, but instead it displays all the records related to cboStaffNum ID.
If I force the field StaffNum to e.g.'2', then the whole system works fine.Leave a comment:
-
Subform data entry is set to YES but it displays all records on refresh
Hi,
On a default startup form (switchboard) I have a combobox in which one selects the username (bound to StaffNum) and clicks OK to open up the mainform.
On the mainform I have a data entry form that has its DATA ENTRY option set to YES.
for StaffNum field, I set the Default Value as
initially the form opens up as data entry, but after inserting new records,...Code:=[Forms]![Switchboard]![cboStaffNum]
-
I have researched and eventually found that a MODEM POOL is required.
I dont know where to source this from.Leave a comment:
-
How to Display incoming Call ID on PC
Hi all,
I am looking for hardware (Possibly a multi modem System) to which I can attach multiple phone lines and connect to either USB or Serial port of my PC.
thereafter I need to write some code in C# to display the caller ID on any of the the lines.
Ultimately, this caller ID will pick out the correct record from a database.
I need someone to guide on the right hardware and give me some... -
MSAccess Freezes and suddenly unfreezes.. not sure why
Hi,
I have an Ms Access 2003 application that decides to freeze itself and the whole PC such that we can click on any ms access control or a windows icon but nothing will happen. but behind the scene, all the clicks are being recorded. Then, all of a sudden, the PC will come to life and all the clicks will be implemented, opening up many windows / dialog windows.
This will also happen on the coding screen.
...
No activity results to display
Leave a comment: