Search results for query: *

I have a grid on a Access 2003 tab form, that I will like to use as a search engine. Once the user select the record, I have a button that is suppose to select the primary key on the grid and use it to find that record on the first tab. I used to use the following process. If Not...

We have designed a program using Visual Basic and Crystal Reports 6. The program is put on the server in a folder that the user is given right to. The ODBC are set up for connection to the database. The problem have just started recently on one computer at a paticular site. The other...

Anyone know how to format a field from a sql server database to currency. For example in sql the field appears as 83.3, I would like it to appear on the web page as $83.30.

Does anyone know how to display a field from and SQL server database as currency. For example it appears as 83.3 instead of $83.30, the field is a money field but sql still leaves it as 83.3. So is there anyway for me to format one field in Front Page?

Dose anyone know how to insert a calculated field on a form to a report. I have tried many way to accomplish this but nothing yet. The problem is that the calculated filed is a combination of 3 other fields on the form, but some of the calculation value are not in the query. The many...

Dose anyone know how to insert a calculated field on a form to a report. I have tried many way to accomplish this but nothing yet. The problem is that the calculated filed is a combination of 3 other fields on the form, but some of the calculation value are not in the query. The many...

Dose anyone know how to insert a calculated field on a form to a report. I have tried many way to accomplish this but nothing yet. The problem is that the calculated filed is a combination of 3 other fields on the form, but some of the calculation value are not in the query. The many...

I have a table called Key Log Out Table that has these fields...

I have a table called Key Log Out Table that has these fields...

This is my first time dealing with asp files. I am a Access programmer who have developed a database that I would like for each sites to be able to add new information.  I have developed a html page with text boxes, and then I tried to link it to our server using the Database result...

Dose anyone have any coding that would check a database, check to see if the SSN is there, if it is then update the information with the new information. And also check to see if the SSN is not there to add the information, or if specified to delete that SSN completly. If so could you please...

Dose anyone have any coding that would check a database, check to see if the SSN is there, if it is then update the information with the new information. And also check to see if the SSN is not there to add the information, or if specified to delete that SSN completly. If so could you please...

I have developed a database that I would like multiusers to used on a network server. But I can't figure out how to make the database accessible to more than one person at a time. If you have any suggestions I would greatly appreciate it.

Does anyone know how to use a Excel worksheet in Access, or how to reference a field in the Excel worksheet.

Does anyone know how to set up a procedure that will check the field in a subform for duplication of Code, and allow the entry if that code has and ending date. For example the program I am designing have BCodes which are benefits codes. The subform is linked to the main form is by SSN. On the...

I am working on a query that I would like to show only record concerned with the beginning date mm/dd/yy where the ending date will be one month only. I've tried ">=[Enter Beginning Date:] + ("m", [Beginning Date] + 1) and this does not work. If anyone got and idea, please...

I have set up a macro that delete the old information and Transfer Text with a link and Append to the table. But when the data changes in the link, how do I update the Link. I could use On Update on the Append Query, but isn't there a faster way.

Does anyone know the best way to update a table from the mainframe server? I have tried<br> TransferDatabase in marco and VB. And Linking the tables, but because one of the<br> table is FoxPro it will not like. I can import the tables from a SP.dbc file, but not from<br> .dbf. But the data...

I'm having problem determining how to show focus on a field in the subform to be inserted into the main form to update the whole form. Both form have StudentID,and I can load the number from a parameter. That way works good, but they wantto have the ability to select a record on the subform...

I have developed a form with three tabs. On the last tab the user wants all students <br> with the same LastName. I've set that up, but now he wants to be able to use that <br> list to update the other two tabs. Should I use requery the combo box, or update the <br> fields in the other two...