Search results

You got it wrong! LOL! I was talking about me!!! I'm 40 y.o. and I 'm barely in the process of learning MS Access. I've been in Networking for the past 17 yrs, I'm comfortable creating DOS batch files and scripts, but never thought I needed MS Access or any programming knowledge. And about...

Thank you!, Thank you!, Thank you! Wow! Its definitively better when you know your stuff! I want to be like you when I grow old! :D Simple to the point without going in circles for a response. Thank you Sir! Learning lots! I have a long ways to go, but with this kind of help I'll get...

Hello everyone, I'll start by saying that this is my first DB.. :eek: I'm having a bit of a problem trying to get this to work maybe someone can give me some direction. What I'm trying to do: I want my main form to show a query result of work orders that are active. This is the code that I'm...

Love you guys! I want to thank Mark and Grey for this post. I was looking for the same type of report and reading this post I had enough information to get it going. And the added bonus of fixing what I was going to encouter, Null values! Just what i needed when I needed it! Thanks...

It's very likely Outlook... ____________________________________________________________ Never mind this post. It helps to read all the posts before posting! :) ____________________________________________________________ I got this from the Corporate office: In order to address time zone...

Hello Everyone, I've been looking at all the fine db samples and advice provided in this forum and they are giving me a huge boost in my new job as a DB Admin. :D Since this forum has a very active group and you guys know and done it all, ;) I thought I would ask if anyone out there has done...

pbaldy I want to truly thank you for your time and efforts! It worked! I had to change the "PrimaryKey" statement to "ItemID" and it then worked. But i would not have been even close to the solution without your help. Thanks! It took me 1 week of reading to get to were i was before it...

This is what I have in place now: -------------------------------------------------------------------------------- Private Sub AddRecord_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String 'New entry strSQL = "SELECT * FROM Items WHERE...

pbaldy thanks for your help...could you do me a favor if it's not too much to ask...could you direct me to the right location to find info on the "SQL string" you refer to on the earlier reply?? Thanks for your help once again. René

Further, but not completely reolved... Thanks pbaldy I truly appreciate your help... that got me further. Now it's stating the following error: ------------------------------------------------- Run-time error '3251': Operation is not supported for this type of object...

Thanks pbaldy! :) Thanks pbaldy! I'll try that!

It worked for me Hailem, I tried this and it worked for me on Access 2003: -------------------------------- Private Sub test1_BeforeUpdate(Cancel As Integer) If Me.test1.Value = True Then Me.test2.Value = False End If End Sub -------------------------------------------------- Private Sub...

Newbie! :eek: While creating my "First Database" it being a OnLoan/inventory database I needed to create a process to remove "OnLoan" Items from the Inventory count. I created a command buton (AddRecord) and added the following code: -------------------------------------------------------...