Search results

Also, you mentioned that the login form should be hidden. What is the code to hide it? I am using access 2007 and I think the command hide is unavailable at present. How do I unhide it when I quit the application?

Thanks for your prompt reply! Very much appreciated! My text box returns the Id number as this is the user id. I want to display the name. How? I am sorry I am not that great as I am on a learning curve with access. My combo box displays the name in the login box but the user id is bound. So...

Hi all! I am very puzzled over this. Maybe you good folks are able to enlighten me. I have created a report by assignee based on a query. When I run the query, everything's fine. The assignee name appeared. But when I generate the report using this query, the name field is blank!! Don't know...

Thanks! But what do you specifically mean? My username in the login form is unbound combo box but my username in the Task form is bound to the username. In this case the userID. Can I just do a query that joins the login table with the tasks table? Is that what you mean? and just pull the info...

Upon logging in, I need to set the username to a textbox in a form and store the field. I have a form named Task and it has a field named Username. This Username is the Masterfield in this form which has a subform. The main form and the subform are linked by the UserID. I am having a big...

Hi All! Problem solved. What I did is delete the old copy in the server and installed a new copy. Works superb now!!!

Dear all! My advance search works perfectly with the ms access db residing in my local laptop. But once i install the file in the server, it does not work!!! I connect to the server via remote desktop. Once logged in, I open the Access db as usual. Everything else works fine but when I use the...

Hi all! Is it possible to automate the row height to increase depending on the data itself in datasheet view? EG. The data in one row is only 1 sentence so the row height is sufficient for that one sentence. Data in the next row may be 3 sentences so the row height must be automatically...

Thanks Big Pat! Your help is greatly appreciated! What more can I say! You solved my problem that has been bugging me for weeks. Thanks again for your Big help!!!

Thanks Big Pat for your prompt response and help. Maybe I am not very good at explaining. What I am trying to do is that if I enter a date in the date field and format it as wk. no. it will automatically comes out that specific week number relating to that date. E.G. If I enter 01/04/13 into my...

Hi All! Does anyone know the best solution to create april 1st as the commencing week for the year instead of week 1 beginning from 1st January? I need to have the week numbers to relate properly to that particular financial year automatically. Thanks!

Thanks StarGrabber! You certainly are a Shining star! Your file is indeed very useful as it does shed some light into whatever I am trying to achieve here. Cheers matey!

A user, Paul creates a task and assigns to various assignees, say John,Jones and Smith. When John logs on as a user, John opens a task form say, and wants to see a list of tasks he created himself and also a list of tasks assigned to him. what is the best approach to create a form to achieve...

Thanks John! But does it work as I have 3 date fields in my multi search. Action date, compliance date and deadline. If I use your criteria how do we know which date field it is referring to? I am not that clever!

For example, I have a few combo boxes and text boxes for my advance search. The search works fine.Is it possible to incorporate a range between two dates into my multi field search? All these boxes are unbound. Possible help??

Hi All! Wonder anyone can help me? I have a main form called Task (master field) which has a sub form named Notes (child field) They are linked by the task ID. I created a button to open the Notes form to add a new record. But I need to link this new note to the current record of the main form...

;) Your help is greatly appreciated! It works perfectly! Thank you very much!!!

i have created a multi field search form that comprises of combo boxes and text boxes. When I run the query everything's great! I created a button to remove all the filters using DoCmd.RunCommand acCmdRemoveAllFilters but I got error msg saying that the command is not available at present! I am...

:confused: but what is the Access function? Thanks for your help!

When I open my task form, I want to set the username automatically to my user name field by using the username from the logon dialog. Obviously after I logged on, my logon dialog box will be closed. So can I still set the username to my task form? Any help is much appreciated. Thanks!