Search results

Hi recently designed a report that works just fine in the design view . I have it setup so that a macro runs the query and then the report based on that query. Problem i am facing is ..when I try to run it at run time from a switchboard it says I dont have permissions to view this object. Just...

I have a report which contains names of various staff which needs to be in rows and then the number of hours for each day of the month they worked- in columns. I am struggling to get it to work so that the first week can be shown on the first page , second week on second page , third week on...

How can I repeat column names and row names on multiple pages of the report ? Thanks. Moses

Employee database :I have a table containing the following ID ( Primary Key) First Name Last Name Department Second table where I enter details of the leaves that they take Absence Records(Primary Key) ID(Foreign key) First and Last Name key (I combine these two in a separate query) Type...

A textbox on a form concatenates 2 strings. I want to insert that resulting string into a table .how can i do that ? moses

I have a subform on a main form. Subform is used for data entry into a transaction table. Subform has a textbox that does dlookup on an ID field from another query. It works fine when I open up the subform on its own. When I open the main form and select the name based on which it is supposed...

I have a query for a database on the shared drive . I want to export this to excel and prompt the user to give the user a file save as box so that he can save it anywhere he wants. Any ideas how this can be acheived?

When I try to do an export to excel for a report - it comes back with a message saying Invalid procedure call or arguement . Any ideas on this one ?

I have an employee database . It has two main tables. Employee Info and other one Details about Types of Leave Taken,number of hours and date on which it was taken. If I want to sum the total for each employee all the types of leave that was taken over a period of time - month or year - what...

How do I sum up the rows of a column in a report ? My example is here below Sick Days Employee1 Employee2 Employee3 Total of Sick Days

Private Sub Combo4_BeforeUpdate(Cancel As Integer) Text6.Value= DLookup("[last]", "Table1", "First ='& forms!Table1!combo4'") End Sub Any ideas about this ? mehul

Pasting a snippet from my code cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\new.mdb" rst.Open "SELECT Table1.Name FROM Table1 WHERE DateTaken= '" & cal1.Value & "';", cnn, adOpenStatic rst.MoveFirst cal1.Value is a value to be picked by the user on a...

Is it possible to assign query result to a textbox on a form without writting VBA code? Thanks.

Hi , I have a report that has data that bleeds on to the 2nd page . Problem is I dont know how to make it bleed on to the next page . Please guide. I have tried extending the section that is above the page footer section and it does not work . it just repeats the data from the first page...