Recent content by Jaykappy

Not sure how to approach this. I have a query that is joining 3 tables by a unique field. tbl_Location (locationID) tbl_Collections (ID) tbl_Gear (ID) There is a one to many from tbl_Location to tbl_Collections If tbl_Collections ID field exists in tbl_Location show me the locationID and all...

Got it Dim Test As Integer Private Sub Form_Load() DoCmd.Maximize Me.button1.Visible = False Me.button2.Visible = False Me.button3.Visible = False Me.button1a.Visible = False Me.button2a.Visible = False Me.button3a.Visible = False End Sub Private Sub...

Trying this now with mixed results... Private Sub Start_Click() 'start timer Me.TimerInterval = 5000 End Sub Private Sub End_Click() Me.button1.Visible = False Me.button2.Visible = False Me.button3.Visible = False Me.TimerInterval = 0 lngTotal = 0 End...

I tried this but dont know how to stop the timer I want to run the code that changes the Form color but want to be able to stop the Timer and reset it to start over... Getting confused there. Will this timer work? Almost like an auction timer...Going once, going twice, sold! But want to be...

I assume that you are referring to this from an Access point of view? I am interacting with this data via a web page using PHP so going to be a bit different...just a little confused on the form and sub form...can you explain this...will help me better understand what you are referring too...

So if I add that table... Then add a new company How do I write a query or allow the admin user to update the users that can view that specific company? That make sense?

Maybe if I create another table: tbl_User_company - user_id - company_id But then how to i update this? sort of confused on the design of it all and how it will flow to maintain the users and new companies added.

I am trying to brainstorm a little database with tbl_Users, tbl_Company, tbl_Employees tbl_USERS - These are USER accounts that will be used to login to the website/db. tbl_COMPANY - These are numerous COMPANY fronts that will be view-able to one or more USERS tbl_EMPLOYEE - These are the...

One last question which I forgot to ask....How can you grab say 4 characters which are in the middle of a 20 character string. I can grab teh front and last like this.... Left([field name],3) & right([field name],5) The deletes the middle, but is their a line that will grab the middle...

I have a bunch of different length values in a field. What I want to be ableto do is Trim the last 4 digits or the first 4 digits. With the queries below I can grab the start or end characters but I want to be able to trim the start or end. Can this be done? If so what is syntax of the...

What I want to do is create a script in database A that will copy a table in database A and push that table overwriting that table in database B. I plan on using Windows scheduler to launch Access and a Macro that will call the module. I just dont know where to start with the module. Does...

Harry, That makes some sense, and was more what I was trying to accomplish. I am sort of new to this stuff and have a couple more questions..... 1. So in Windows Scheduler I would create a script that opens the database and runs a macro: "c:\program files\microsoft...

Hello - I hope that someone can lead me in the right direction or have some sample code I can use for my question. What I am trying to accomplish is update (on a time interval) an Access Database on a server from another Access Database residing on my network. The database on the Server will be...