Did you check out the file I uploaded? LookerOffice.zip. Basically, I followed your advice and created two join tables: tblCustEquip and tblEquipWork because I...
6467
simon larsen
goats_fan
Jul 29, 2002 10:32 pm
A string cannot be null, a variant can. So use: Dim Serial As Variant Serial = Me.txtSerialNumber.Value If isnull(serial) Then MsgBox ("test") End If Simon...
6468
shavetak
Jul 29, 2002 10:52 pm
After evaluating the Products By Category report in the Northwind database, I am unable to understand how 3 columns are defined in Access. If you look at the...
6469
enZo :-)
onestepclose...
Jul 30, 2002 9:10 am
Hello ! ! ! I have 146,726 records on my Tranx Table. Are the number of records already a factor to slowdown searching of records? (usually it tooks more...
6470
Petru Boboiciov
petru_boboiciov
Jul 30, 2002 9:19 am
Yes, that's right, and the number of users it's a factor to slowdown all operatinons. ... From: "enZo :-)" <enzaux@...> To: <ms_access@yahoogroups.com>;...
6471
richard_davis@...
bombluv69
Jul 30, 2002 11:57 am
Do you have the field that you are searching on indexed? "enZo :-\)" <enzaux@... To: <ms_access@yahoogroups.com>, <access@...> t>...
6472
sunray4805
Jul 30, 2002 12:00 pm
I am looking for some help in developing a data base for the purpose of managing tenanted & vacation homes. Factors for Tenanted. Home Owner Tenant vendor ...
6473
Pigeon01
Jul 30, 2002 12:00 pm
I have questionnaire which I want to convert from Word to Access, so that I can input and save date. How can this be done? Thank you....
6474
richard_davis@...
bombluv69
Jul 30, 2002 1:07 pm
I don't think so. "Pigeon01"; <pigeon01@yaho To: ms_access@yahoogroups.com o.com> cc: Subject: [ms_access] CONVERTING WORD TO ACCESS...
6475
bdloving
Jul 30, 2002 2:49 pm
Text if isnull(field) or (field = "") then Numeric if nz(field,0) = 0 then is the field where you want the default date bound to a txt box? if it is...
6476
tomaswalther
Jul 30, 2002 5:28 pm
I'm trying to add a caption to a field(s) in a table. so far... y = 0 Set db = CurrentDb Set Tbl = db.TableDefs("mytable") ...
6477
pcc202
Jul 30, 2002 6:56 pm
Thnak you for your help i can do this for office2000 but office XP came loaded with the laptop i bought so i dont have CD. Will I be able to download help file...
6478
drgokulk
Jul 30, 2002 7:19 pm
Hi, I am MS Access user with no knowledge of Visual Basic. I have created combo boxes in Forms which search for ID's and names from the form. But in one...
6479
Brett Collings
zkbac
Jul 30, 2002 9:24 pm
... Slowly, painfully and manually. Unless it is in a table then you can cut and paste it to a new table Brett...
6480
Brett Collings
zkbac
Jul 30, 2002 9:39 pm
... I can't see a fault in there, but I do have a general comment for everyone in general about the naming if fields and controls. What doesn't look safe, ...
6481
Brett Collings
zkbac
Jul 30, 2002 10:36 pm
... If you paid for it, then they cannot supply XP on a machine without supplying the CD. Demand it or threaten to report them to Microsoft for Piracy Brett...
6482
Brett Collings
zkbac
Jul 30, 2002 10:36 pm
... It's probably not appropriate to ask someone here to create your database for you ... but we'd be delighted to teach you how to do it and help you to learn...
6483
simon larsen
goats_fan
Jul 30, 2002 11:51 pm
Save it as a text file and try the import wizard. If it is a small questionnaire probably the manual method will end up faster though ;) Simon Larsen DBA ...
6484
JvegaA
Jul 31, 2002 12:46 am
Hi Guy's, Need a little help and a fresh eye. I'm trying to create a process that stops a user from entering a record in a table if the record already exists....
6485
simon larsen
goats_fan
Jul 31, 2002 1:08 am
Just put a unique index on the SQL box on the home phone. No code, no muss, no fuss. Unfortunately no pretty error message either. Try it and see, it'll be...
6486
Guy Harley
guyharleyaus
Jul 31, 2002 1:32 am
Try the following. Although I haven't tested it, it should work. I would also recommend that you name your fields differently from your controls to avoid...
6487
hutchide2002
Jul 31, 2002 5:20 pm
I am a relatively new Access user, with little knowledge of Visual Basic. What I would like to do is transfer a record from a form into an excel spreadsheet,...
6488
richard_davis@...
bombluv69
Jul 31, 2002 6:01 pm
Are you looking to delete the spreadsheet or the record in the database? "hutchide2002" <hutchide@dow. To: ms_access@yahoogroups.com com>...
6489
hutchide2002
Jul 31, 2002 6:44 pm
Yes I am. Well, I am trying to clear the record so when the next person uses it, the first record cannot be seen (it is a confidential database that only I...
6490
stonededagain
Jul 31, 2002 8:12 pm
Hey All: I have a subForm with a calculated field in the Footer section. I want to view it in datasheet view when I open the main form, but I am not able to...
6491
Alexander Shaw
breedlings
Jul 31, 2002 8:39 pm
I always look through the messages and occasionally there is a question that I think I may be able to help with .... could someone explain the question please?...
6492
Alexander Shaw
breedlings
Jul 31, 2002 8:39 pm
... From: Brett Collings [mailto:bac@...] <<SNIP>> I always make field names descriptive and try to avoid the use of common names which may be...
6493
Crosier, Dawn
dlc110161
Jul 31, 2002 10:27 pm
I have created a front end ADP connected to a MSSQL database. I have copied the front end to the users machines. My problem is that they are not seeing each...
6494
enZo :-)
onestepclose...
Aug 1, 2002 2:26 am
Lo!!! I have 40 plus number of fields per record, do you think is this still good enough? Or this will already have effect on search and queries? Enzo ...
6495
simon larsen
goats_fan
Aug 1, 2002 6:12 am
It's probably not great. You could look at vertical partitioning (make 2 tables with a 1:1 relationship) or look at whether some of the data really needs to...
