Search results

  1. Villarreal68

    Issues with code...

    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...
  2. Villarreal68

    Issues with code...

    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...
  3. Villarreal68

    Issues with code...

    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...
  4. Villarreal68

    Report Calculation - Access 2003

    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...
  5. Villarreal68

    Outlook inbox time messed up

    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...
  6. Villarreal68

    specific Item tracking database

    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...
  7. Villarreal68

    Recordset issues...

    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...
  8. Villarreal68

    Recordset issues...

    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...
  9. Villarreal68

    Recordset issues...

    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é
  10. Villarreal68

    Recordset issues...

    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...
  11. Villarreal68

    Recordset issues...

    Thanks pbaldy! :) Thanks pbaldy! I'll try that!
  12. Villarreal68

    Yes/No fields

    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...
  13. Villarreal68

    Recordset issues...

    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: -------------------------------------------------------...
Back
Top Bottom