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...
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...
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...
I'm getting kind of confused with the whole clientside and serverside scripting. In the past I only used server side so now when I wanted to implement a msgbox things aren't going my way.
What I want to do is when a button is clicked on a ASP page, I want a message box to pop up with whatever...
I'd say I'm a beginner when it comes to SQL so bare with me. I'm trying to create a query that deletes a record from one table and 2 more tables that are linked to that record. I've been using the query design to help me along with my sql, but it isn't working. What I have so far is this...
I have a weird error, I've got 3 scripts in a cgi_bin folder that are called from buttons or links on my web pages (on NT 4.0 server using IIS). 2 of the scripts work fine, but the third one makes the download window pop up. I'm really confused, I would think the download window would pop up...
My question is this: I'm trying to copy the contents of a folder everyday and store it in a folder with the date as the name of the folder. For example, when batch file is called (with the at scheduler at night) it would create a new folder with today's date as the name. Then it would copy...
What I'm trying to do is make a form where the user can enter a select statement to search a Access database(has multiple tables). And how would I post the results on the Grid so that only the selected columns get shown. It seems to me you have to prepick the columns that you want to be...
I'm looking for a free(and somewhat easy)way to upload files from the client to the server.. The only software I'm finding to do this is not free, so I'm wondering if anyone knows of any other software that works well with Interdev that will upload files for free.. Thanks!
I'm pretty sure that my problem lies with single and double quotes. My line of code is the following:
='<center><a href="Hardware.asp?ssi=' + [System_Site_ID] + 'site= '+ [site] + '">Hardware</a></center>'
I'm trying to pass 2 different variable from a database. I can pass one...
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.