help with query!

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Oracle Tables I am attempting to connect to Oracle tables using Frontpage 2000 through an ODBC connection. I can set up the database connection fine but when I ask it to show me the available tables the drop-down list only shows me a few of the available tables but not the ones I need. Is there a limit in this list or something? I tried to use a query statement but it then tells me that the table or view I am looking for does not exist. Any ideas? Thanks!! Tag: help with query! Tag: 31177
  - 2
    - HTML email Would appreciate help with creating a HTML e-mail with graphics. Thanks! Tag: help with query! Tag: 31176
  - 3
    - Re fphover I have a problem regarding fphover-classes. In some Swedish Internet Explorer (the latest update and all) fphover-buttons doesn't show, they are just marked as a broken link. The strange thing is that it's not in all Swedish browsers, just all the new computers with fresh installations of Windows XP. Is it a matter of security in the browser or what can be wrong? Thanks! Niklas Tag: help with query! Tag: 31174
  - 4
    - Compare and synchronise Database files I have two web sites both using the same datbase and both are accessed by a different group of people. What I need to be able to do is synchronise the two Acess Database files to automatically update the one with the oldest 'date and time of modified' so as to keep both files mirrored. This would obviously need to be a regular background process I think that was the best way to explain the issue. Graham IndiVisual QLD Tag: help with query! Tag: 31172
  - 5
    - System requirements Hi, I want to buy FrontPage 2003, but it is unclear to me whether Win ME will run it. I don't need to build massively complex sites, just a few for small clients of mine. The system requirements seem a little vague as written: Win2000 or later, and WinXP. Does that mean that WinME, which falls between those two, will run FrontPage 2003? TIA, MTL Tag: help with query! Tag: 31169
  - 6
    - Sync Web Site Hello. I am using Frontpage 2000 on Windows XP. Works fine. The other day I had to FTP in from another location thank where my Frontage resides and make a change to the web site. No problem worked fine. However, now when I make a change with Frontpage, I wants to overwrite my change I made with an older file version on my frontpage computer. Can I somehow sync the file on the web server with my frontpage here? Cheers mark Tag: help with query! Tag: 31168
  - 7
    - Interactive Button Problem Problem I'm having with the interactive buttons is I can only getting one image to save and as a result when Previewing in Browser am only getting one state and no interaction. When I Preview the buttons in Frontpage 2003, I get and - Internet Explorer Script Error - message. Any help would be much appriecated. Tag: help with query! Tag: 31161
  - 8
    - FrontPage 98 VS 2003 I have FrontPage 98 which I have used to build web pages which I have then FTP'd to the server. Now I have a web host which uses Front Page extensions on their Unix based server. I don't mind spending the money to upgrade to FP2003, but I would like to have a better idea of what I am going to get for my money. Thanks, Dave Tag: help with query! Tag: 31156
  - 9
    - Frontpage & MS Access DB I have suddenly run into a problem saving data into an Access Database. The form has worked in the past but now it "Acts" as if it's working by reporting the correct response form "ie: not an error response" but the data does not save into the table. I am fairly familiar with FP and Access so I beleive I have checked everything. ALSO, I tried "creating" a NEW database right from Frontpage. It created fine and link it's "results" table but still won't save the data. ANY HELP would be very much appreciated. Could it have something to do with the FP Extensions? I have made no changes to them. Tag: help with query! Tag: 31154
  - 10
    - Mouse Roll Over I saw a web site that when you rolled the cursor over a thumbnail picture the thumbnail replaced the larger picture that was displayed next to the thumbnails. Is this a feature of Front Page. If so, how do I use it.... it certainly was cool. Thanks. Tag: help with query! Tag: 31151
  - 11
    - page cut off in print preview in IE When I do a print preview in Internet Explorer in my web site, www.taxtips.ca, the right side of the page is cut off. I have looked through prior messages, checked to ensure my tables do not have width in pixels, but 100% or less. Any advice? Thanks! Tag: help with query! Tag: 31150
  - 12
    - How to use JavaScript with FP form Hello: I want to use a JavaScript function that validates the e-mail address in FP form. This works great with any non-FP form. In Fronpage, however, I have these problems: If I use it like with the regular form: onsubmit="return emailCheck(this.Email.value)" - it doesn't work; If I use it like this: webbot-onSubmit="return emailCheck(this.email.value);return FrontPage_Form1_Validator(this)" - it works, but any other validation doesn't. If I change the order like this: webbot-onSubmit="return FrontPage_Form1_Validator(this); return emailCheck(this.email.value)" - all other validations works, but my function doesn't. How to use this JS function so both would work - the FP validation and JS function? I would appreciate your help. Thank you, -- Peter Afonin Tag: help with query! Tag: 31149
  - 13
    - The Sever Connection Timed Out Hi, All I want to do is synchronise my mdb online with the one on my local host. It is 1.25meg. I do not want to always have to use a separate ftp client to do this. Why can't FP03 transfer files this large? There doesn't seem to be any patches available for FP03 yet to resolve this issue? Am I doing something wrong? Specs: 2mbps cable, XP Pro, Host using WIN2K, IIS5.0 Cheers Dennis Tag: help with query! Tag: 31148
  - 14
    - onload auto click of Submit button in short this is what i want to achieve. an 'onload auto submit' this is what i want it for. i use a intranet at work, when staff visit a page it already has the files selected depending no how it is that has visited, all i want is for the page to auto click the GO button, to save then doing it. how do i have a page auto click this button? maybe something on the lines of <onload ....> ?? these files are agendas and each person has only interest in some, so using cookies i have set up what ones they want and when the open the page it then downloads the files the want and not all of them, i am trying to save time sending out emails to everyone with just the doc's they want, this is very time consuming. so hence the script to do it. all i need is to have a bit in there in the form part to auto execute it, or SEND when the page is looked at. thanks in advance. Jason Tag: help with query! Tag: 31146
  - 15
    - Search Engines Hello group, I'm going to put up my first web site, using frontpage, and before I do I want to understand search engines and how I need to prepare my site's html. I have 'Hello Engines' and 'Ranking toolbox', but trying to use these 2 programs leaves me with more questions than answers. Are there better tools out there? Thanks Fred Tag: help with query! Tag: 31145
  - 16
    - front page 2002 I posted a message earlier about my website being out of whack when viewed from opererating systems other than the one i created it on (xp). I didn't have this problem before when I created essentially the same website with fp 2002 using win 2000. If you would like to view my simple site it is: www.citychickendesign.com. I am definitely a novice at this so please be patient. Thanks! Tag: help with query! Tag: 31143
  - 17
    - Form Help Is it possible to send a form in the same format as I seen on my web site? I don't want a database, just a copy of the form filled out. This is what I get back and its too hard to read. brickwork.net/time.asp <snip> Fri: Sat3: Job4: Wed9: Wed12: Thur6: Fri7: Mon8: Sun10: Job11: Wed24: Sat13: Mon14: Fri16: Wed36: Thur18: Tue19: Tue20: Wed48: Sun22: Job23: Sat25: Mon26: Wed61: Fri28: Thur31: Name8: <snip> Tag: help with query! Tag: 31142
  - 18
    - Unable to send form results to an email Hello~ I am currently using Frontpage 2002, running IIS 5.0, Win2K. I'm pretty familiar with FP, but have had some problems having the form results sent to an email. I can set up the form to have the results send to a database, but that's it. Now the form is set up to e-mail results when it's submitted - however when I save the form, we get the following FP error message: ---------------------- This form is being created on a disk based web or the FrontPage server extensions have not been configured to send e- mail ...etc... Would you like to remove the e-mail recipient? yes/no ----------------------- Properties of the form are set correctly and as far as I can tell, SMTP Services and FrontPage extensions are installed correctly and set up for e-mail to indicate the correct SMTP Server and email addressses to be used. IN addition to the problem saving the form discussed above, whenever the form page is accessed by a visitor (or through a browser locally) it shows a line that says "[FrontPage Save Results Component]" at the top of the form, and whenever the form is submitted, the user gets the following error message: ------------- FrontPage Run-Time Component Page You have submitted a form or followed a link to a page that requires a web server and the FrontPage Server Extensions to function properly. This form or other FrontPage component will work correctly if you publish this web to a web server that has the FrontPage Server Extensions installed. Click the <Back> arrow to return to the previous page. ------------------ I have already done the following: Re-created the form. Checked that FP Extensions and SMTP services are installed & as far as I know, configured for e-mail Read and followd KB Articles 197605 & 196489 HELP!!!!! Thanks in advance Nicole . Tag: help with query! Tag: 31141
  - 19
    - tracking counterS on 1 page I would like to display the .cnt file(s) info from 6 (working) counters onto 1 page. All the counters (& files) are within 1 site. When I use inline frames, iframe does not want to display the counter file info in the frame, I'm prompted to 'open' or 'save' only. (ie; 'index.htm.cnt' wants to open rather than display on the page). I cannot find a way to change the saved counter file extention and would rather not copy to local. Is there a way to display counter info from the .cnt files within a webpage ? TIA, Tom Tag: help with query! Tag: 31137
  - 20
    - FP 2003 Hotspots do Rollovers? Hi all, Made hotspots within my page in FP 03...wondering if it's possible to add rollover effects to these hotspots. I just want my menu selections to do something different when you hover on them... here is the link to the page in question... www.ddh1969.com/testhome.htm The links right under the logo at top of page...any help is apprectiated. -- D- www.ddh1969.com Tag: help with query! Tag: 31136
  - 21
    - Form Handler - Can't select any "send to" buttons I'm trying to modify my form properties to send data to my email, but all is grey except "send to other" Tag: help with query! Tag: 31135
  - 22
    - frontpage background in frames and cells when i make a table and click table properties or cell properties i cannot set a background picture in it , i can olny make a background color ,the tab for use a background picture is faded and i cannot select it! please help i cannot get my work done Tag: help with query! Tag: 31129
  - 23
    - ATTN: John Jansen COPIED FROM microsoft.publiv.sharepoint.windowsservices John, I like your suggestion, but I am obviously doing something wrong. It says, "There are no items to show in this view of the "test" list. Here is what I did. 1. Opened the Sharepoint site with FrontPage 2003 2. Created a Web Part page 3. Dragged the "test" list to the right column 4. Right click to open "List View Properties" 5. Clicked on Filter 6. Clicked on "Click here to add a new clause" 7. Entered Field Name "Last_Name" Comparison "Contains" Value "[T1]" 8. Dragged the "Form Web Part" to the left column 9. Right click on "Form Web Part" to open Web Part Connections Wizard 10. Entered: Provide Form Values To Connect to a Web Part on this Page Target Web Part "test" Target Action "Get Sort/Filder From" Columns in Form Web Part "T1" Columns in test "Last_Name" Finished 11. Saved the page What did I do wrong? John "John Jansen (MSFT)" <johnjan@online.microsoft.com> wrote in message news:e2pdlZg2DHA.536@tk2msftngp13.phx.gbl... > Sorry I'm jumping in here late. I believe the steps below will get you what > you want using Connections from within FrontPage 2003... > > Convert the view you want to be filtered into a Data View Web Part using > FrontPage > Create a filter where your Field Name CONTAINS [Input Parameter] > > Insert a Form Web Part onto the page > Use Web Part connections to pass the Form value as a parameter to the Data > View > > Save the page. > > -- > Thanks! > John Jansen > Microsoft Office FrontPage > This posting is provided "AS IS" with no warranties, and confers no rights. Tag: help with query! Tag: 31124
  - 24
    - Stored Proc use in Database Results Wizard Hello. I am trying to use the database results wizard with a stored procedure that happens to use some temp tables in its execution. FP Database Results Wizard is choking on this, stating the temp table is an invalid object. This seems awfully constricting, so I am thinking that I am missing something. Might someone be able to assist? Thanks. Kevin Tag: help with query! Tag: 31123
  - 25
    - OWC Getting message "query could not be processed" when inserting office web component in frontpage. any ideas? Tag: help with query! Tag: 31119
- Next
  - 1
    - Import existing GoLive web site I need to import my existing web site that was published with GoLive. Can this be done without disaster? Tag: help with query! Tag: 31111
  - 2
    - Fix a police and font size in all document Hi, Could you tell me how to fix a font size for all my HTM files in order to avoid any problem if user change the police size of his internet explorer. Thaks. Tag: help with query! Tag: 31106
  - 3
    - FP2003 - Form / Query Problem Hi Im new to this so please bear with me ...... I have created a form in FP 2003 which adds records to an .mdb file. When the user submits the form, I want the confirmation page to show not only the detail that has been submitted but also the record number, user name and IP address of the users computer. I decided (rightly or wrongly) that the best option would be to put a basic query onto the confirmation page which shows the latest record added for that user or IP, thus showing the user what he had just added and also giving him a record number should he need to chase his request. The problem is, I do not seem to be able to retrieve the user name at all. This is not even posted when the user submits the form even though I have requested the user name. The IP address is added, so I wanted the query to compare the current users IP address with that of the records in the file, thereby displaying to the user the latest record for his IP. I cannot however figure out how to retrieve the IP address from the users computer to compare against the database records. Does anyone know how this is done and can it be used as part of the SQL statement. All help appreciated Sean. Tag: help with query! Tag: 31098
  - 4
    - FP 2003 applet preview does not work -- why downgrade? I have spent literally hours trying to find how to get FP 2003 preview mode to properly display. Finally, I found KB 323236, which says YOU CAN'T. This was also a problem in FP 2002, and MS didn't fix it. I am glad I still have a copy of FP 2000 to reinstall after removing FP 2003. My question is: why downgrade to Office 2003 components that don't work when Office 2000 components have more functionality. I am sick of MS garbage that does not work as advertised, and they know it and yet we still have to "eat the dogfood." DO I GET A REFUND for purchasing this fraudulent and defective software? Tag: help with query! Tag: 31097
  - 5
    - Block IP Address HELP!! I have a pesty competitor who is constantly at my site. Is there a way in FP for me to block his IP address from accessing my site? PLEASE!! Any and all help would be greatly appreciated! Thank you, Michelle Tag: help with query! Tag: 31095
  - 6
    - Checkbox checks other checkboxes? Hi I would like to have one checkbox change the value of another checkbox. In Excel I was able to acheive this with the following: Private Sub CheckBox011_Click() If CheckBox011.Value = False Then CheckBox012.Value = CheckBox011.Value End Sub What would be the syntax to do this in Front Page? All I have is this and it doesn't work... <input type="checkbox" name="checkbox1" onclick="checkbox2.value=checkbox1.value"> Thanks MBo Tag: help with query! Tag: 31091
  - 7
    - Link bar with subdirectories I am trying to figure out how to in MS Frontpage 2002 how to have a website that has link bar buttons when you hover over them with the mouse that a subdirectory opens that has a list of all the subsequent pages that that page links to. A dropdown or sideways subdirectory that opens showing visitors the contents of the site is what I am looking for. I have the links currently based off of the navigation structure right now, and all I want is to make it so that you can see what pages the link buttons go to while the site is live on the web. Thanks and any suggestions or advice will help! Tag: help with query! Tag: 31089
  - 8
    - last modified date isn't updated after publishing I just published changes to my site on the web. My changes are visible on the web, but the last modified date showed an old date. I have the last modified date in a shared border in Front Page. Thanks for any help to this mystery. Tag: help with query! Tag: 31088
  - 9
    - Music on web site In the past, I have placed music on my web site using *.ram and a *.rm files. The *.ram file is a metafile created by a text editor and the *ram file is created by Real Producer. I am finding that music produced this way is taking too long to buffer and stopped several times while playing in order for more music to buffer. Is there a better way to do this? If so, how? Tag: help with query! Tag: 31087
  - 10
    - help with code! Hello! The scenario: I have a .asp page that contains a form with a database results component. The database result is a query that will return cercain amount of records from an access database. The question: How can I make the form to show different buttons depending on the amount of records returned by the query? In other words, if the query returns no records I need to show BUTTON_A; if the query returns 1 record I need to show BUTTON_B; if the query returns 2 records I need to show BUTTON_C and so on... The actions associated with each button should be different, lets say each button redirects the user to a different page. Please help!! Thanks in advance. Tag: help with query! Tag: 31078
  - 11
    - Remember password automatically I am servicing 2 web-sites using Front Page 2002. I use to be able to have a log on name showing when I started Front Page and it remembered my password. Now, for some unknown reason, the automatic logon field doesn't show up anymore. Can anyone help me please? Tag: help with query! Tag: 31077
  - 12
    - discussion posts Sorry if this is in the wrong place. Anyway, if I have a discussion, and I want to either delete or edit a post, how can I go about doing so? I am so lost. When I open the TOC it won't let me edit the text. Any help would be GREATLY appreciated. TIA, Ryan Tag: help with query! Tag: 31076
  - 13
    - Forms Hello All, It seems that forms are the most popular request and problem here in these newsboards so I will continue the fun. I have created four forms and all of them work fine by e-mailing the results to a e-mail address as programmed. Now here is where my question comes into play: I want these forms to send the data to a database and I know how to get the forms to do this. But how do I know when data has been submitted and how do I get the data from the databases? Thanks in advance, Brian F. Tag: help with query! Tag: 31074
  - 14
    - Allow for Print Options I can't figure out how to allow my webpage users to choose their print options, such as "as laid out on screen" and "selected text." How do I do this? and how can I prevent the text on my webpages from being cut off when printed? Tag: help with query! Tag: 31073
  - 15
    - VB6 applications and FP We wrote a vb6 app that queries a mainframe and displays the results using MS Charts and Hierarchial Flexgrid. works fine, everybody is happy.....now they want it available over the net. We use FP2000 to build our webpages. Can I ..how do I run the application from FP. Hints will work (aim me in the right direction). Code examples are even better. Thanks Tag: help with query! Tag: 31072
  - 16
    - Database Results Page & Graphics I have a database results page pulling info from an access database based on a single criterium entered by the user. It is working fine other than the fact that one piece of returned information is a graphic which is not displayed. Instead, it returns [#binary#] in its place? Can anyone tell me what I'm doing wrong? Thanks alot. Tag: help with query! Tag: 31070
  - 17
    - invisible hit counter - not working in Netscape I have created an invisible hit counter by creating a 1 x 1 pixel transparent image and choosing custom image in Frontpage 2003. Works great in Internet Explorer, but when viewed in Netscape, looks like a missing picture. I don't want anything there and it looks tacky in Netscape, any ideas? My new site goes live this weekend and I want it to look good. Tag: help with query! Tag: 31069
  - 18
    - FrontPage 2000 and Windows XP Everytime I try to publish a web from FrontPage 2000 using Windows XP I get a message that I need Windows NT. Is there something I should download or is there a conflict of some kind? Tag: help with query! Tag: 31067
  - 19
    - transfer my web. Ok if I want to tranfer my webs from one computer to the other, can this be done even though the new computer does not have frontpage? And if so then is it just a matter of plugging something into them and using the transfer wizard? what and were do I plug this (if you don't mind answering this). Thanks Tag: help with query! Tag: 31062
  - 20
    - Display problem When I view the page in FrontPage, it's fine, but on the web it looks like this... http://www.remingtongroup.com/bsa-pics/ Tag: help with query! Tag: 31060
  - 21
    - Navigation bar from FrontPage I have a navigation bar in some web pages, generated by FrontPage. They work OK on my development machine under IE and within FrontPage.. When the pages are transferred to a server on the Internet, which has it FrontPage extensions switched on, the home page comes up without any buttons in the navigation bar. The hit counter, also FrontPage-generated, works on the Internet server. The code generated in the homepage is follows. How do I crack this problem? _____ HTML code in the homepage (I don't know why the font is so small...): " <td width="757" height="27" valign="top" bgcolor="#CCCCCC" colspan="2"> </td> " Tag: help with query! Tag: 31058
  - 22
    - Adding text to FRAME PAGES Hi all My Index page has a Frame Page format. I'm trying to add descriptive text below the pictures in the 'contents' frame. I cannot get the text to appear below the photos unless I add, experimentally, an variable number of lines below the picture. The text appears in the required area in development but moves up and behind the photo in preview. What am I missing for placing the text on the frame? TIA -- ********************************** Shar Feldheim ** A small town in Minnesota http://www.grandymn.com Tag: help with query! Tag: 31057
  - 23
    - Copy locking I have FP 2002 and I would like to make sure that people cannot "right click" and copy things from my published website. Does FP have this feature? Tag: help with query! Tag: 31052
  - 24
    - Acces Data Interface I am new to this and would like to know if there is a site that can walk me through on how to add a database to my website. I would like to have members to input there member number and name and in return for them to see there information such as address and if their dues are due. Any help would be appreciated. Thank you Lee Tag: help with query! Tag: 31050
  - 25
    - Hit Counter I would like to keep track on vists to my page, however I do not want to make it public. Is there a way to hide the hit counter so only I can see it? Tag: help with query! Tag: 31034

hello!

In an ACCESS database I have a table with an autonumber
field, I need to know the value generated for the
autonumber field everytime I post a new record to the
table. How can I do that? I suposse this is a very basic
question but I'm new to access.
The database will be accessed by multiple users at the
same time and I cannot query the last record of the table
to find out the autonumber assigned for it's possible
that a new record has been entered by other user in the
meantime.
Please help me with this one!!

thanks in advance!

Top

Re: help with query! by Jon

Jon
Thu Jan 15 13:18:35 CST 2004

Hi,
you could do
<%
YourConnection.execute("insert into...
set rs=YourConnection.execute("select @@identity")
response.write "new id is " & rs(0)
%>

--
Cheers,
Jon
Microsoft MVP - FP

"AAA" <anonymous@discussions.microsoft.com> wrote in message
news:0b8701c3db86$11410400$a601280a@phx.gbl...
> hello!
>
> In an ACCESS database I have a table with an autonumber
> field, I need to know the value generated for the
> autonumber field everytime I post a new record to the
> table. How can I do that? I suposse this is a very basic
> question but I'm new to access.
> The database will be accessed by multiple users at the
> same time and I cannot query the last record of the table
> to find out the autonumber assigned for it's possible
> that a new record has been entered by other user in the
> meantime.
> Please help me with this one!!
>
> thanks in advance!

Top