Search results for query: *

hi i currently allow the users to enter in a time value of hh:mm and i have a javascript that validates the data. The problem is i would like to input this data into sql database but an error comes up by not enabling the ':' to be inputted into by smalldatetime field. So i would like to...

Hi I was wondering does anyone know how to undo a record from a different form. For example when the user goes back to the main menu, multiple forms will close and if the user has inputted any data it will undo the record. Therefore, when they press the back to main button, only once, all the...

Hi I have data stored in a table like my look like this GXHU - 1245 TS - 124587 What i would like to do is seperate the data by the "-" so in one field there is GXHU TS and in another field 1245 124587 Can this be done with a query? Reta

Hi I have data stored in a table like my look like this GXHU - 1245 TS - 124587 What i would like to do is seperate the data by the "-" so in one field there is GXHU TS and in another field 1245 124587 Can this be done with a query? Reta

Hi, How am I able to format my list box with VBA code to have a horizontal scroll bar on the screen. Currently it only displays a vertical scroll bar with no horiztonal one. Reta

Hi, How am I able to format my list box to have a horizontal scroll bar on the screen. Currently it only displays a vertical scroll bar with no horiztonal one. Reta

Hi I was wondering is there a way that i could provide the user with a browse button to browse their hard drive for a particular file they would like to import into access. At the moment i have assigned a folder that can import their files from, however some of them would like to browse their...

I have a input box and i would like to place a date mask over it, using VBA code. Is it possible? Reta

How am i able to check if a checkbox has been check with VBA coding. Thanks Reta

Hi Is there a way of creating TWO primary keys in a table in access 2000. Thanks Reta

I was wondering does anyone know a function that i could place infront of a query, that will allow the query to remove a $ from infront of a a field in the database. EG $12345 it should be 12345 Thanks Reta

In the database it gives the user the option of selecting a record and all the data that relates to that peice of data will be displayed. This therefore allows them to edit the data and update the db. However, at times the user may not which to update or delete that record and return to the main...

Does anyone know how i would be able to copy a whole table in ms access without, inserting each record from one table into the new table. In other words am i able to copy the contents of one table into another. Thanks Reta

Hi i am trying to import a file into a table i have used this code before and it has been successful, however when i created a new program a tried to import information from an excel spread sheet i get an error. Error Description: Application defined-error or object- defined error. run-time...

i have a db that is linked to an excel spreadsheet, but when i add a recordset that links to the spreadsheet it gives me an error "type mismatch" CODE: Dim dbs As Database Dim tdf As TableDef Dim rs1 As ADODB.Recordset ' Open the Microsoft Access database. Set dbs = CurrentDb '...

Hi i am importing an excel file into access, but i need to merge the first two cells in the excel file before the file is imported, as the headings are broken up in to two cells. I know how to merge cells in excel, but i need to know how to merge cells in the excel file through access, is that...

I am currently building a access db in access. A form will pop up prompting the user to enter in the file name of the excel spreadsheet and once they press a button all of the information from the spreadsheet will update and added to the existing information in that table. The problem is i dont...

Hi i am creating a db that connects to another accees db, in a different location and they may not be connected at all times. Therefore, i created a button in which allows them to connect to my db and compares their data to my db and updates or inserts records into my matser db. The problem is...

i have a report that gets its information from a query. i would like to know how to compare the dates in the db to todays date.So i can display the items that are overdue.

I have a db and i would like to count the number of fields related to that ID. In my onloans table i have the the ID of the person and the serial number of the product and i would like to count the number of serial numbers the person has borrowed against their ID. Once this is done i would like...