That's interesteing John, I wasn't sure of my ground on whether time was included so I went to XP version's Help which said "for date and time" ... so I...
Dear all, I'm new member of this community. I'd like to say hello to every one here :-).I'm learning access right now. I'm at VBA. Does any one wanna send me...
I have an access 2000 DB and I am trying to update a table relationship but when I attempt this I get the error "record(s) cannot be deleted; no delete ...
Jeremey- What version (and Service Pack leve) of Access are you using? Did you convert this database from an earlier version? John Viescas, author Building...
Brett - Thank you for the note. I guess I didn't do a very good job with the question. I was hoping to avoid the use of any of the functions in Access like...
Mike- How are you getting the data into Access? If there's an external file, is it text? It would seem to me you could link a text file, then write a query ...
Hi John - The data is being exported automatically via an "Auto Export Setup (see file uploaded with same name AutoExportSetup.jpg) from a software package...
Mike- If the output is Text, then you'll have to do an explicit convert to date/time data type to be able to stuff it into a date/time field in a table. John...
It is important to have the right "Reference" set and in the right order. I am never quite sure of which reference file needs to be involved but look under...
How do you have the object Dim'd in the first three lines of code? You could simply pass it as an Object: Function Get_Columns_and_Rows( ... , ExcelDoc As...
Actually, there's probably a library in Tools / References marked "MISSING." Uncheck that, and everything should start working again. This often happens in a...
John - I can output it as a number if I knew what that number needed to look like. Do you know what I mean? Put it another way - let's say I was in Access...
Mike- You can enter a date/time value from the keyboard exactly like that. Try it in Nortwind Orders table - type (or paste) that string into OrderDate, and ...
I am already using the MS Excel 9.0 Object Library reference, so I did suggestion two and it works like a champ. So, thanks again, John. As an author maybe...
Gotcha - Thank you again John. Mike ... that. Try it ... OrderDate, and ... text ... convert it ... On Behalf ... Like? ... needed ... ps.com, ... convert ......
Hi All: Hopefully someone can point me in the best direction. I am charged with the task of writing a boat dock reservation DB in Access. I am "fairly"...
Check out MotelBooking compliments of AD Tejpal, if I remember correctly, it will help you find available Motel Rooms, which you should be able to translate...
Dawn: Thanks for the swift reply. I will D/L it now. =Dave R.= If you own a Hotel, A B&B, An Inn or a Full service Resort YOU'RE LOSING MONEY DAILY.......START...
Hi Dawn: YOUCH, He's GOOD....Guess I've got my work cut out for me. (Hopefully not a complete re-write of what I already have but I like his style :-). Thanks...
A method that I used with success in the past for something similar - you will need a dedicated column to accept a 'marker' in a timeline table. When the slip...
Hi Les: That sure does sound more like something simpler that I could incorporate into my existing DB. The "marker column" sounds perfect. I'm not even ...
Hi All: This should be simple but at 2:24am I just can't jog my memory enough. Can anyone help with a swift kick to the side of my head? I have a dropdown box...
DRR- Use the Column property of the combo box. Column(0) is the first column, Column(1) is the second, and so on. Me.txtCost1 = Me.MyCombo.Column(1) John...
John: Thanks for the swift kick to the head. It was just what I needed. =Dave R.= If you own a Hotel, A B&B, An Inn or a Full service Resort YOU'RE LOSING...
Millions of them. It's one of the key areas that small businesses use Access (often rather badly) Brett ... -- Brett Collings Strengthening Families...
If you want to take someone else's and modify it, I can't help you. If you want to buy one, all I can suggest is googling until you get the right fit. If you...
HI All, Please help me with this problem. I want to retrieve all fields from an existing record using combo box. So here I have 3 combo boxes....A,B,C. In...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
