Ideally I'd like to add a new field ( Yes/No ) to a table on the fly. Is there a way to do this in access. At the time I have a Insert query built to add new records but if I could just add a new field to an existing record it would greatly reduce the size of my database.
Thanks
This could be a beginner question since I'm still learning to use forms in access. What I'm trying to accomplish is to have a form open a subform that displays all the records in a datasheet view. I got that to work but now I'd like to have it set focus to the last record of the subform...
At the time I've got a login/password page that requires the user to tab down to the "login" button to submit. This login button calls the function btnLogin_onclick() which holds all the computing for the page.
What I want to accomplish is when the user is done typing in the login...
Hi everyone, I can't seem to find any examples of how to pass parameters to a command object. This is what I have so far :
cmDatabase.CommandText = "INSERT INTO Utilities(System_Site_ID, Utility_ID, Utilities) VALUES (var1, var2, 'Erase')"
I want to pass the variables var1, and var2...
Hi everyone, the last week my web server was giving me big problems so I reloaded iis 4.0 and NT 4.0 option pack on my NT box. It cleared the problems I was having but it brought about a new problem. Now my DE commands stopped working and I'm getting an error with my global.asa file on a line...
Sorry about that, it was a typo. What I wanted to say is the following:
Right now the user has to either tab down or click the "submit" button I created. I'd like to make this process easier by having the enter key act like the "submit" button.
Any ideas? Thanks!
Hi everyone, I can't figure out how to submit my form when a user hits the enter key. Right now I have it that when the user hits the enter key the form is submitted, but it would be much nicer if they could just hit the enter key to submit.
Thanks!!
Here's my problem. I'm trying to add different security levels to my website by using session variables. I've got an updatable grid on my pages that I want only read only for some users and full access for others. The only way I could think of to make this possible is to make 2 data source...
My question is regarding how my FTP site looks and adding more features to it. My site is on the Intranet so security is not a problem. What I want is for people to easily search and upload files to my FTP site. At the time, I have it so users can copy and paste (doesn't work for NT)...
Hi everyone, I've got a question regarding viewing Excel documents over Internet Explorer. On my website I have links to excel spreadsheets that are located on several other servers. Everything works great if the user has excel loaded on their pc, but that's not always the case. So is there a...
Thanks Ian, your answer lets me view the tables now by double clicking but only works the second time you double click. But that's good enough for me. Thanks!
Thanks RTorrance, your commands worked. I still don't understand why the table just doesn't open without any commands. I used to do it all the time and today it doesn't work. hmm.. Thanks
Until today I could just double click a .dbf file in windows explorer and it would launch VFP and open the database. Now when I try double clicking a .dbf file I first have to associate it with VFP and then it gives me an error that a .fxp is not an object file. Does anyone have an idea of how...
I've got 2 DTC listboxes in a Parent/child relationship format. Everything works good except when you hit Back on the browser the "parent" listbox doesn't refresh, yet the "child" listbox refreshes. I had this problem for a while now and can't seem to figure it out. Here's...
I'm just looking for ideas on how to implement a very simple message board. I do not need usernames and the other stuff that the usual message boards have. I just need a small box that would appear on the page where any user can type a sentence into it and leave a message.
If any of you...
I've got a listbox that gets populated from an Access table. Then I got a button below that when clicked erases the highlighted record. My problem is this: when I do a listbox.gettext() it always returns the first record no matter what record is highlighted. So I believe the listbox is...
Thanks alistairpaul, my msgbox is client-side and working it's just that I want to call a server-side subprocedure from a client-side subprocedure. I was hoping there would be a easy way of doing this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.