Search results

I have a SQL Server table that contains datatypes of decimal. When I link the table in an Access database the datatype shows text instead of decimal. This is causing an issue when someone tries to enter a value with a comma. Has anyone had a similar problem. Do you know if there is a way to...

I need code to get an array of dates between 2 dates. For instance 2/1/2009 through 2/10/2009. I want 2/1/2009, 2/2/2009, 2/3/2009 etc. They are stored in my database as the Beginningdate and EndingDate. Can anyone help with this. Does anyone have any suggestions on how to do this?

I have 2 option groups on a form. The first option group allows a user to pick from a list of reports and the second option group lets them choose between a detail or a summary report. However, there are 3 reports that have no corresponding summary reports so I'd like to turn off the summary...

I wrote the following code and it does not work. I would like to be able to copy the contents of one table to another table with the same name but with the current date appended to it. I'm getting extremely frustrated with this and I have asked other people here and no one seems to be able to...