473,387 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Calculating age errir in VB 6.3

Hello!
I'm trying to work on a database for someone and they're having a few
troubles getting things working.

They use to have this program on another older computer but they recently
got new computers and just copied and pasted this database from their old
computer to the new one. What they do is just open the database that looks
like it's sitting on a server and right now they're having troubles adding
clients.

When they go to the add clients form and try to enter their birthdate, they
get the following error:
Compile Error: can't find project or libray.

From there it opens up the MS VB debugger and goes here:
Private Sub Text23_AfterUpdate()
Text21.Value = IIf(Text23.Value = "", "", (DateDiff("y", [DOB], Now()) \
365))
End Sub

With the [DOB] highlighted. I don't really know what command they're using
since I'm beyond rusty on VB and I don't really know Access too well, does
anyone know what's going on? Thanks!
Nov 21 '05 #1
2 990
Sounds like this is an Access VBA question and not a VB.NET question.
"Tommy" <To***@discussions.microsoft.com> wrote in message
news:A5**********************************@microsof t.com...
Hello!
I'm trying to work on a database for someone and they're having a few
troubles getting things working.

They use to have this program on another older computer but they recently
got new computers and just copied and pasted this database from their old
computer to the new one. What they do is just open the database that
looks
like it's sitting on a server and right now they're having troubles adding
clients.

When they go to the add clients form and try to enter their birthdate,
they
get the following error:
Compile Error: can't find project or libray.

From there it opens up the MS VB debugger and goes here:
Private Sub Text23_AfterUpdate()
Text21.Value = IIf(Text23.Value = "", "", (DateDiff("y", [DOB], Now())
\
365))
End Sub

With the [DOB] highlighted. I don't really know what command they're
using
since I'm beyond rusty on VB and I don't really know Access too well, does
anyone know what's going on? Thanks!

Nov 21 '05 #2
"Tommy" <To***@discussions.microsoft.com> schrieb:
I'm trying to work on a database for someone and they're having a few
troubles getting things working.


Notice that this is a group dedicated to VB.NET programming. For
VB6-related questions consider posting to one of the groups in the
microsoft.public.vb.* hierarchy.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Ron Adam | last post by:
Hi, I'm having fun learning Python and want to say thanks to everyone here for a great programming language. Below is my first Python program (not my first program) and I'd apreciate any...
0
by: Kasp | last post by:
Hi there, I am trying to make an OLAP cube on a table having two columns (datetime, Number_of_times_an_event_occured). My dimension is time and I want to measure the Min and Max times an event...
1
by: Joe Bongiardina | last post by:
What does the message "calculating...." mean in the lower left status area of a form? I have a form with no calculated, concatenated or lookup fields, yet it displays this msg. The form takes...
1
by: jlm | last post by:
I have a form which feeds table (TblEmpLeave) of Employee Leave Time (time taken off for Administrative, Annual, Sick, Compensation leave). I have EmpID, LeaveDate, LeaveType, LeaveHours fields on...
0
by: robin9876 | last post by:
In an Access 2000 database on some forms 'Calculating...' is continuously displayed in the status bar window and the text of the control is automatically selected. The only workaround is switching...
5
by: sugaray | last post by:
Hi, my problem with calculating the size of an array is when I pass an array as a parameter to a function which perform the calculation, the result never comes right, like below: int...
25
by: Umesh | last post by:
i want to calculate the time required to execute a program. Also i want to calcute the time remaining for the execution of the program. how can i do that? pl mention some good websites for...
1
by: laredotornado | last post by:
Hi, Can anyone recommend a free script for calculating UPS shipping? I am familiar with the script written in 2000 by Jason Costomiris, but UPS is using an XML interface and I wondered if...
4
by: =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= | last post by:
Say I have a class like, class Sample { public decimal first = 10; public decimal second = 20; } I have initialized it
4
by: sumit kale | last post by:
Hi, Can somebody help me resolve my problem ? I am getting error when calculating total using unbound textfiled in subform. I have a main form called purchase_register_master and a subform...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.