Search results

No, I don't want to change the structure of the table. I just wanna update the value of a field. I have a "tasks" table that has a "HowOften" and "NextScheduledDate" field. Let's say that the user filled up 'weekly' on the "HowOften" field. So whenever this "NextScheduledDate" = to today's...

Record traversing on OnLoad event hi, On the OnLoad event of a form, is it possible for the program to traverse or go through every single record (maybe with a while loop)?? If so, please send me the exact syntax. Also, I want to update the tables on the back end. Is it possible to this in...

hello, how is it that I make a table "updatable". That's the error ACCESS 2007 gives me when running the runtime version (front end) on a computer. The program has to update the tables on the back end which are on a different computer (on the same network). Also, I just saw a thread with...

hello, I have a password textbox on a form. As the user types in his password I want the textbox to display the '*' symbol, just like on any log in page. How do I do this? thanks

Read-Only error hello, Now the path is recognized, so that part is working. Now when the file is open from another computer X and I click on a button on the startup form, it says that there's a run time error. When clicking on this button the program is supposed to update some tables on the...

reply it should be the ".mde" of ACCESS 2007 which is what I'm using. The tables are linked to the fe.

reply The message is: 'E:\database_be.accdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server to which the file resides.

The only thing I did is to split the database and 2 files appeared: "database" and "database_be". I took "database" (which I am assuming is the fe) and installed it into the other computers and it gives me that error. Sorry, I have never done this before so I'm very lost, I don't really know...

kidrobot: Yes, E: is on the network hello, I have an external hard drive "E:" on computer A. I split the database in this hard drive. I installed the front end on the Desktop of all the rest of the computers. How do I link the front end to the back end because it's giving me an error saying...

Hello, I have finished a program with ACCESS 2007 (VBA) at work. Now, my boss wants his employees to use it from different computers. What would I have to do to make this work?? I suppose ACCESS has a runtime version or executable that I can install on every computer of the company? Or do I...

hello, Let's say I have 10 variables (ID1, ID2, .........,ID10) In java, I can use a while loop as follows to go through each variable For example: i=1 j=1 while (j<=10) { ID+i = 0 //this is some type of initialization of each var to 0 i = i + 1 j = J + 1 } What would be the...

hello, another problem that I have is as follows: I have 2 txtBoxes and a button (txtA, txtB, btn). When opening the form I fill in txtA and txtB. Now when clicking on the button "btn" (OnClick event), the program is supposed to compare the values in the 2 txtboxes. If they are equal...

Hello, I have a form (linked to a table). I have 'txtBoxA' and 'txtBoxB'. Now, each record will have different values in 'txtBoxA' and based on that value 'txtBoxB' will change for that specific record. In the 'OnLoad' event for the form I type the code, but when I re-open the form it only...

hello, I have 2 questions: 1) How do I add an icon to a form in ACCESS 2007 (and where do I get it from)? 2) How and where do I create different user accounts for the data base (ACCESS 2007)? Thank you very much

hello, I have 10 combo boxes on a form looking up at the same table (fileld A). I want the user to be able to enter a new value (that's not in the table and therefore neither it is in the combo box) to the 1st combo Box (let's say) and that same value to be automatically added to the table...

Sorry then, I did not know you could do that

I already have a job table and a quote table which are related. It would be the same information but a different date, but would still be different quotes. I believe that based on our needs, it is better to repeat the neccesary information in the new quote. If you know how to do this, I would...

I did not, I just clarified the problem Thanks

I am implementing a quoting system at work. Many times, a customer wants the same job that he asked for last year or 2 years ago, so basically it's the same information. So when the customer calls, I look for his last quote, and then would add a button that would create a new quote (record) but...

I am implementing a quoting system at work. Many times, a customer wants the same job that he asked for last year or 2 years ago, so basically it's the same information. So when the customer calls, I look for his last quote, and then would add a button that would create a new quote (record)...