Search results

I may be misunderstanding a little. But i dont think you need the "salary" feild in the first table. Just create a join between the two tables based on EmployeeID, and in your query include all fields between the two tables. the resulting output / screen would give you the following...

there it is! Anyway to reactivate it without needing to remove the table links and re-adding them I've got about 150 linked tables on my file

I wonder if because i'm only allowing it to use 2003 version i dont get that. when I create a new link to a table, I only get the following options "Use trusted Connection" Login Password "Change password" (with new pasword and confirm password) Database Language Application name Worstation...

I have an MS-SQL backend which i use for my data source. I then use Access for reporting services. (It works so much better than SQL Reporting Services 2005). this seems simple, but i can't get it to work. Everytime the users start up access, It pops up a login and password for the ODBC link...

tell me about it! I started here 3 years ago as billing clerk. I decided in my spare time to write access reports that will help me get payroll and billing information out of the cumbersome, stupid and quite frankly hard to use front end. I then moved on to create a PHP / MYSQL database in my...

create a button on your form. in that button set it to open a macro when clicked. in the macro, just set action to "Outputto" than in the bottom sections just fill out the details of the object type, name, format, filename

Yes. you would create a table with an OLE object. than you could just paste the file you scanned into the OLE feild

Thank you. it needed actually one more thing, But that was the basic idea just putting that however in the feild caused an error saying that it was an invalid Macro. However, creating an event procedure with that inside it worked. Thank you

I'm creating a submission form that launches a Query. Pretty simple stuff right :p. however, I'm stumped and having a hard time how to autoupdate one feild in the form once another field is entered. Basically. I have a report that has a "start" and "end" field. I want the user to enter the...

Sounds simple doesnt it? So why can't I? here's the scoop. Ive written an Accounts receivable aging report. it prints a range of clients all in one report and subtotals for each client the information. However, we have some clients that obviously go on for pages. I know that i can't do a Page...

there's a function to use in Queries called DateDiff(). DateDiff («interval», «date1», «date2», «firstweekday», «firstweek») for intervals you put the letter corresponding to the format. "d" for days., "w" for weeks. and so forth. (Bust use quotations.)

Hi everyone. I'm having some issues creating a query i need for work. I'm able to do this on the report level with a group and footer to get this total. however due to further complexity and Queries that will call upon this one, it needs to be in the first level query i create. What i have is a...