Hi there, I instaled MSDE (Microsoft Desktop Engine), small version of SQL Server, and I want to find out how to conect my Access databases to MSDE, so it will...
Makes sense....I tried it just now though and it still doesn't work :( Any other suggestions? L. ... the Report Open event is fired there are no values in the...
I have a table with the following fields... Grossweight, Tareweight, Tons, ProductRate. I would like to create a form for data input where I could either put ...
Hope I haven't asked this question here before. I didn't see how to check what I have posted. I am entering dates, ticket numbers, and other data into a form...
Group, I have invested a lot of time in creating import specifications in one of my databases. Is it possible to move or copy those same Import Specifications...
Group, FYI - This is possible and I found the fix here: http://support.microsoft.com/kb/119472 I just tried it and it worked like a charm! Thanks, Izzy ... ...
New to this group, was with Access Professionals prior, obviously that was the wrong place for me, very helpful group, but way over my head. Anyway, I have a...
I have a dbase of terminology from some years back and I am becoming more and more frustrated at not being able to update or edit the entries because the...
Dear Harold, The easiest way to update a password is to create a new user with a password that you know. You can then go into the database, copy your password...
In a membership database, I have a table tblSubscriptions. Several fields, but essentially MemID, DatePaid & AmountPaid. I want to create a query to display...
Just thought I would ask if anyone has tried the new version of Access yet. I have a legacy database in Access 2000 for a client, I use 2003 and was thinking...
Ii Eileen On a slightly different note. Did you have any problems with your Access 2000 databases running under Access 2003? I've updated one of our PCs to...
Eileen, I tried Dmax, but could get it to work in my situation. However, Dana's query/subquery works well so haven't pursued DMax any further. Thanks for your...
Hello There I wanted to calculate the no of days between two dates in a table where the deduction should be done column wise not row wise Eg Tran date ...
Hopefully this bit of code will help: Carry the Value of a Textbox Forward to a New Record Private Sub Form_AfterUpdate() 'For every Text Box you want to Carry...
Sorry for this quick and rough answer. If FinishTime<StartTime, FinishTime+1-StartTime , FinishTime-StartTime. Hope you can work out what to do from there.... ...
I have a self program in vb that run very well in win xp pro but in win xp pro x64 show the following warning: database is open in exclusive mode by anhoter...
Hello All Members, My name is Atique. I m new one. Please help me how can we connect a access form with Excel worksheet. I mean i want to make a form for input...
Have a look at the directory where the access database resides. You might find a file with the same name as your database, but with an .ldb extension. Rename...
Greetings from cold & snowy NY state I am new to Access. I saw a report that printout an alphabetical listing and each time the last name changed a larger...
I currently have a query that concatenates the last first and middle names of a client into one column. My expression is here below: =[Client_Lname] & ", "...
You'll need to do an "iif" statement... FullName: =iif([Client_Mname] is null, [Client_Lname]&", "& [Client_Fname], [Client_Lname]&", "&[Client_Mname]&" "& ...
Never heard back from anyone on this one? Any ideas out there? This works for hourly reports...just want to break it down further. ... From: Dave Moreau ...