Hi, quick question.
I'm making a select query on a table. 1 of the columns is date. I want to do 2 queries, 1 which shows all the records where the field date has a date and the other where it...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22941892.html
Hi,
I have a table which has the fields
F1 = Name
F2 = ID
F3 = Group
However, i want the table to be
F1 = Name: ID (name and ID joined, with a : and then space)
F2: Group
i hate access ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23476238.html
This should be simple but for some reason I am not having any luck. I am trying to convert a poorly field in an excel sheet into a number value. All the text is in put where it has 200k or 1M so ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23519671.html
Zones:
MS AccessDate Answered: 06/26/2008 Rating: 9.4 Views: 0
Hi there,
I'm creating a query in Ms access from a table. I'm trying to set the criteria, where I can filter data where
fieldname not a OR b OR c or etc..
but when I give such a condition, it on...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23039177.html
Hi Experts
I have a strange problem here with me. We have a Data warehouse in Oracle that has reporting through the standard report tools like BO and Cognos, but there are a lot of users who use...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design...
Zones:
A...Date Answered: 07/16/2008 Rating: 7.6 Views: 0
good afternoon,
i'm trying to edit records in a table where a column should be null. this is what i have but it keeps givin me an error object required
Set db = CurrentDb
Set rs = db.OpenRe...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23642595.html
Zones:
MS AccessDate Answered: 08/12/2008 Rating: 8.0 Views: 0
This question has been asked to me by a friend.
I'm deep into a file server migration, of a bunch of data 7+TB, and there are a lot of access databases. For instance in one 170GB Share, there we...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design...
Zones:
A...Date Answered: 09/25/2008 Rating: 7.6 Views: 0
pls refer to http://www.experts-exchange.com/Databases/MS_Access/Q_20885247.html. need to filter data that i placed in a form according to date range. thx
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20887448.html
Zones:
MS AccessDate Answered: 02/17/2004 Rating: 9.8 Views: 0
hello,
I get this error: the text file specification " file name " does not exist.
I have an old back up for this mdb that the transfer data works fine.
there are few hands that work on this app...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23849208.html
Zones:
MS AccessDate Answered: 10/26/2008 Rating: 7.8 Views: 13
Any Idea?
The form only shows a blank calendar when a new record is created.
I suspected it had something to do with a null value. But I found that even if I set the Calendar.Value = 4/20/200...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24338028.html
