Search results

Thanks Kodo, I will definetly look into the links and information you gave me. You are absolutely correct that it is not anything massively difficult or indepth, just a few querries to fill in some data fields, and user interface areas... like I said it is for generating helpdesk information...

I have a SQL Enterprise server that I am using a MS Access to remotely access and populate the tables from my laptop into a database. Based off of the linked data between my project and the true SQL database, I have created some Access Data pages for interacting with the data. What I need to...

I have a SQL Enterprise server that I am using a MS Access to remotely access and populate the tables from my laptop into a database. Based off of the linked data between my project and the true SQL database, I have created some Access Data pages for interacting with the data. What I need to...

*bump* *Bump*

I have a SQL Enterprise server that I am using a MS Access to remotely access and populate the tables from my laptop into a database. Based off of the linked data between my project and the true SQL database, I have created some Access Data pages for interacting with the data. What I need to...

The Time off data is a projection of 30minutes later when the individual needs to get off the MWR asset. Just kind of a visual tracking. So yes, the seconds are supposed to be the same. However the actual log off time will vary to when they actually get off the machine.

So I take it you can't do individual anything to records in continous form (buttons, text boxes,etc.) correct then? :( Suggestions on how to do something like this, (a different method)?

Yes I'm using 2k. I've tried using conditional formatting for a few other things and the one problem that I have run into is getting it to update things in real time. If I understand correctly it needs to be requerried to refresh all the information correct? So if that was true, would putting...

Ok... The project is nearly done and I'm just trying to put on the finishing visual touches in the forms. Here is a picture of my form (see attachment) The clock is realtime, and the log on/log off buttons add users and remove users from the MWR assets. The formality of the DB is not...

subform and gotorecord notes ok, it just dawned on me to search again in the forums for someone elses questions and I found this. Would this work for what I'm trying to do?

Yes the record in the subform and the record in rs are exactly identical, in fact so much they are the same record. I'm not sure if the bookmark function would work for this as from what I think I understand in the help pages.... I would never be able to set the bookmark property in the same...

Any help please?

Thanks Dan, I think this might work. I haven't had a chance to implement it yet, but I'll give it a shot. :) What I have been working on is that annoying search algorithm. I got it to work beautifully except for one part. Transfering this newly located record to a subform. In a re-cap, The...

I should have seen this coming. Since my form shows all records having a timed event like this works. And gets the txtBox to appear and disappear as appropriate. However instead of it only showing on the effected field, the one record where it is < Now(), it makes the property change to all of...

that's a lot like what I did already, I was hoping there was a way to go in by index value only. If it helps to see where I'm going I'll post the code later. I'm just trying to run a binary recursive search because when I complete the database, the number of entries it will have to go through...

that would be one way to sum it up. I was just grabbing a specific line from my recursive search algorithm, that was giving me problems. Basically the UserNames is just a string that is a column in a table and the records. I'm searching for a specific string and instead of going through...

ok, thanks for the help on the second part, I'll try that out. As for the first here is what a list search would look like: ------snippet--------- If StrComp( target, Left(lisnames.ItemData(index -1), Len(target)),1)=0 Then....... -----end snippet--------- Where target is a string, and index...

ok. On to phase two of my little database. It now contains over 255 entries and the simple query I was using is slowly slowing down. So, broke out the old coding books and found a nice recursive search algorith to use. I create the following: Dim rs As Recordset Dim index as Integer set rs...

Actually there was nothing wrong with it. About an hour after I sent this, and a 4 mile run later, I sat down, and looked at it again. Suffered from the smacked head syndrome and quickly got back to work. See... I said it most likely was easy and I was doing it the hard way. lol. Thank you...

I' m a self taught learner in Access and this is my first major project. I'm writing a database to manage a MWR facility. It has a tracking system by user that contains what MWR asset they got on, at what time on what date and when they got off. So far I have been doing ok, perusing these...