Search results for query: *

Hi, I posted the following in the SQL forum but would also consider doing this in access. I am trying to generate a check sum from a number such as 2300282697345. I can do this in excell but have not found a way to do it in SQL. How I do this in excell is take the number from the first...

Hi, I am trying to generate a check sum from a number such as 2300282697345. I can do this in excell but have not found a way to do it in SQL. How I do this in excell is take the number from the first worksheet and in a second worksheet I take the first number as it is(2), take the second number...

Hi, I have a script that allows people to input user information such as first name, last name, etc... and writes it to a flatfile. Is there a way then to check the entries for duplicates, copy the first 50 entries ouf of the database (flat) and email them to a person, then remove them from the...

Hi, I have a script that allows people to input user information such as first name, last name, etc... and writes it to a flatfile. Is there a way then to check the entries for duplicates, copy the first 50 entries ouf of the database (flat) and email them to a person, then remove them from the...

Hi, I have a cgi that allows people to input user information such as first name, last name, etc... Is there a way then to copy the first 50 entries ouf of the database (flat) and email them to a person, then remove them from the database and store them in a secondary database? Any help is...

I am trying to retrive a username from the registry in windows xp. We are on a Novell network. I used the following but it doesn't work. tName = QueryValue("HKey_Current_UseR\Volatile Environment", "NWUSERNAME") Me![txtClosed] = tName Me![Date Closed] = Now()...

I am trying to write a macro that will reset check boxes once a report is run. I have tried the following but none have worked. Set Value: [Query]![envelopes].[Value] =Off Set Value: [Query]![envelopes].[Value] =False Run Code: me.checkbox1.value=vbuncheck

One of our users has a problem with every file they save. They are running Windows 98 2nd Ed. with Office XP Professional. When they save or retrieve files, all the files have the web designation (%20) for spaces. So a file saved as "my file.doc" looks like "my%20file.doc&quot...

Is there a way to dynamically list the contents of a directory on a server in a web page?

Is there a way to have the contents of one field on a form be copied to another field on the same form?

How do you convert an ascii character to its integer value (example the ascii character is 5 I need the integer value to be 5)

Hi, I am using the vb script at the end of this message to assign sessions to students. It works for the most part, however, every few records the order of assigned sessions is reversed for no apparent reason. Any help would be appreciated. Thanks ' Recordsets Dim Studs As Recordset...

Is there any way to export a table to excel and have excel pre-formated (Font type, font size, column width, row height,etc...) Thanks

Hi, I created a control to open a search form based on a search using the following criteria: To open the form I use the event DoCmd.OpenForm "Search User", acViewNormal, acEdit The form itself has the sql query: SELECT [Contacts Temp].PIDMs, [Contacts Temp].PIDM, [Contacts...

I am creating a dynamic filter as per Microsofts ACC:How to Dynamically Create a Filter. I created all the text boxes and macros and they work ok, the problem occers when I create the OnClick event procedure. According to Microsoft the command is Filter.Apply Filter When I create this...