Search results

I have a criteria in my report that prompts the user for input when they open the report. I just have [Enter date] on the query criteria the report based on. I would like to show the "entered criteria" on the report when the report is open. Can someone tell me how to? I'd like a heading label...

I am visiting friends. Their neigbhour just got a pet goat. A dwarf goat playing in their yard. I thought goat was supposed to be eaten!! Fried, grilled, boiled, roasted. Now here's a source of meat playing in a neigbhours yard for pete's sake :eek: Flaunting and showing off. And the goat is...

I have a three tables: Employee table (empId, firstname, lastname) Positions table (positionId, title)--{lists positions} EmpPositions table (empId, empPositionId, positionId) Not all employee have positions (i.e. not all employees have records in the empPositions table). Some employee's...

I want to insert data into a table where a symbol does not already exist for that date. I am not sure what i am doing anymore :( So please help me verify that this won't insert duplicates? Am i using the correct logic? :confused: "INSERT INTO StocksData (Symbol, [Security Name], [Market...

What's the fastest, best and most efficient way to learn flash (in web development) and be up and running in due time (well with practice of course). Can someone teach me if i pay?

Generally, I feel like i never learn until i actually fall flat on my face. Then i know not to go that route again. Can't be like that with everyone, can it? Or am i just stubborn cos even when the signs clearly state "do not trespass" is when Mslady loves to stroll into the forbidden ground...

Okay! I've had it! Why is crosstab query a nightmare in sql server :mad: This is absolutely ridiculous and i can't imagine why they left the feature out :rolleyes: Seeing as this is just a piece of cake in Access and it will run smoothly without pulling teeth but i am made to understand (by the...

Beloved Access gurus, I am wondering if it's possible to export specific columns into certain positions in the textfile? I haven't seen this done with Access before so i dont know. I have an access table that i would like exported periodically into a textfile (meaning, i have to do this with...

I'd like a code to lock a table in my access database so that it can not be mistakingly deleted by the user. It's a very basic database program i am using for basic reporting purpose. I'd like to lock the master table from the user. How can i achieve this? Any ideas?

Can anyone help me convert this pivot query to work in sql server please? I'll love you forever if you help me please :pTRANSFORM Count(Employees.MaritalStatus) AS MaritalStatusCount SELECT Employees.MaritalStatus FROM Employees INNER JOIN Offices ON Employees.OfficeId = Offices.officeId WHERE...

This works perfectly. SELECT DOCSADM_PROFILE.SYSTEM_ID, DOCSADM_PROFILE.AUTHOR, DOCSADM_SECURITY.THING, DOCSADM_SECURITY.PERSONORGROUP, DOCSADM_SECURITY.ACCESSRIGHTS FROM DOCSADM_PROFILE INNER JOIN DOCSADM_SECURITY ON DOCSADM_PROFILE.SYSTEM_ID = DOCSADM_SECURITY.THING WHERE...

The security table is made up of two primary keys: thing, personorgroup When i run this statement to insert into the security table INSERT INTO security (thing, personorgroup, accessrights) SELECT '252600649', '4020', '255' FROM PROFILE WHERE not exists(select * from security where...

There are those builtin bmp images in access e.g. delete, edit, select, filter, etc etc. I am trying to access the location of these small bitmap images and use them for a web application i am creating. Do you know where they are located? I am searched with no luck. Someone also sent me an...

I am pretty new to access security and would like to implement one into a small database i have just created. This datbase is located on the network. I want only 3 users (by their username) to have read/write access to the tables in the database. Everyother object should be locked. Everyother...

I need to implement a Quick search feature in my employee application so that when any text is typed into the textbox, it searches the db for a match: e.g. firstname lastname ss# employeeId deptId officelocation deptname it returns the record in the employee table that consist of the text...

I want to automatically hide all the tables in the database, and automatically hide any new tables that are created, imported thereafter, except one mastertable. How do i achieve this?

I am trying to design a database for an HR management system. I am not very clear on how to handle historic employee data in this database and will need some help and advice please. Any comment you can provide, i'd really appreciate it. We will like to have record of historic data and the date...

This is a game: Pick a member of the board and post what you believe they cant live without based on what you know/observe about them, heard, or their online personality. You are welcome to use pictures...:D Okay, let's begin...

How do you refresh,reload,requery a report? My report opens from a buttonclick on a form based on criteria on that form. When i click to open the report multiple times and in each time changing the criteria on the phone, it doesn't refresh the report to the newly specified criteria. It still...

Hello my beautiful worldwide friends :D I am trying to calculate employee Overtime hours from their recorded TimeIn and TimeOut if over 7.5 hours. So anyday they work past 7.5 hours should be calculated and totalled at the end of the week. And i can't seem to figure it out, maybe my maths is...