Search results for query: *

Oh my God this is exactly what I was looking for. Thanks so much gmmastros !!!!!!!!!!!!!!

USING TSQL on SSMS 2005 I have a table with entries in two columns: Location, Widget. I want to get a second table that has rows of all locations with all widgets. Or I could settle for a table (with the two columns) that has Locations where the rows for the locations have a widget where the...

I have an 2010 Access DB on Win 7. I have a query in the DB that often accesses tables that are linked to SQL Server tables. This never used to happen before, but all of the sudden this started to happen. I will open this query and while it runs I am prompted for a machine data source. I go...

Can you help me with an alternative that might be more efficient and quicker than what I have in these few lines. I am inserting some records from a temp table into another table that already has records, and I have just one condition. Here is my code: Insert into #MainTable Select * from...

I think I tried that but I will try again and let you know

I have an Access 2003 application where the mdb is a front end and all tables link to SQL 2000 tables in the back end. I have been told that the reports I have created within the app (thru Access) have to have their date fields set up so that 1/1/2009 becomes 01/01/2009. No zeros can be dropped...

Thanks to all...all your answers were valuable !

I am working with a Access 2003 application someone else created and left unfinished. In this situation, a user can click a search button on one form (based on criteria the user chose), and this will bring up another (very complex bound form). This form will show where the user can scroll thru...

I have a form with a lot of text boxes on it. When the form is first displayed to the user, I want to make sure he cannot type into any of them until a button is pressed. Can I use just one line of code to make sure all of these are locked? Or do I have to wrie a line of code for each one. I am...

I am curently modifying an application created by someone else no longer at my company. I notice that, while running the application, when I am in some parts of the application, there will be some "options" added to a toolbar at the top. These options are actual forms that are part of the...

Thanks. I pretty much had to shrink the size of all the individual items on the design of the report and then move them over. It was a pain but it worked.

I am in an Access ADP project file and I had to add a column/field to a report. The new column and the values for it display correctly. However, since I had to make this new column the third column, I had to move the remaining 10 columns over. That was no problem. I just used my mouse to give me...