Search results

Thank you- that helped

Hi, I am importing a file into an access table that have hyphens in the number. How do I remove the hyphens once the numbers are in the Access table? Thanks, P.

Hi, I have a table with employee data. I have a field that has a "start date" of employees and a field that has "current date". Is there a query I can run that can count the number of days beween the start date and current date? I need to be able to track the number of days the employee has been...

I unchecked all the options and it worked. Thanks much. P.:p

I don't want the toolbar at the top to show. In other words I don't want the option of the "view" and be able to go to "design view" to be there. Am i missing a step? Thanks, P.

Hi, When opening an access database, i want it to go straight to the form. I tried tools/startup/display form/page. That is still not getting it to do what I want. I don't want any of the toolbar to be shown. Thanks,:o P.

Thanks for the help. I got rid of the concat query and it worked fine. thanks P.;)

Hi, I have a form with a command button to execute 2 queries. Here is the code I have: Private Sub Command7_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "Concat Query" DoCmd.OpenQuery "Make Table Query" DoCmd.SetWarnings True MsgBox "Execution Complete" End Sub When I run...

thanks this helped

Hi, I have imported data from a csv file. One of the fields coming in is in a time / text format. Once I bring the data into the table, is there a query i can run to convert the text field to a number? thanks, P

thank you --- that will work

Hi, I'm trying to import an excel file to access using the command button with the following code: DoCmd.TransferSpreadsheet transfertype:=acImport, tablename:="Test", filename:="C:/PKP/Test2.xls", HasFieldNames:=True My excel file has many blank columns in the middle which i do not want to...

How do I import a a table into access from excel automatically using VB script? Thanks,

Hi, I have two tables that have the same fields. I want to compare the two tables by each field. So if one table does not have the same exact records as the other, then i want it to spit back what rows the two tables do not have in common. I tried using the unmatched query wizard, but it only...