Search results

I have a lot of fields in a particular query and its field names are quite long. But I need to limit the number of pages needed for print out of the query. Is it possible for me to adjust the height of the column label so that the wider field name adjust's itself in a narrower but broader...

Hello, I wish to automatically set narrow margins and orientations before issuing a print command in the code. This is what I have done so far: Application.Printer.Orientation = acPRORLandscape Application.Printer.BottomMargin = 362.834645669 Application.Printer.TopMargin = 362.834645669...

Hello, Yes I changed the names of the fields from Date to Date1. What I mean is, i have an additional control source on the form called 'DateText' and when the user inputs a particular value using date time picker. I want the DCount command to check for that dates repeating values. Your...

Hello vbaInet, Thank you for the above syntax and its arguments. I tried in as a test and it worked appropriately for a particular date. Now, For my case, I need to replace the Condition of "Date = #2 jan-10" with something like "Dates in the field are equal to each other". I want to have a...

Hello, Thank you for your prompt reply. But What i dont get is what should be the 3 arguments inside DCount( , , , ) function which enables it to give the count of values for which there are repeated entries of the Person for the same date? I am really confused hw to write this statement...

Hello, It keeps telling me, Cant find the form, even when I put the form name as correct. Thanks. Kindly help

Hello, So I should put the name of the control after the form name or I should put the name of its relavant Field? Thanks

Hello, Can you help me more on how to use it in the after update event? Thanks.

Hello, I have a table called 'DateID' which has 2 important fields 'Date' and 'Duty'. The date can be set to any value thereby having multiple instances of the same date. For instance, the entries are, Date | Duty | Dept 1 jan-10| Person1 | A 2 jan-10| Person2 |...

Hello, Thank you so much with your last post. I realized i messed up the syntax. But when I press Forms("Form_name").______ it should give me suggestions for fields right? The only options i get are of the forms properties. Thanks, Kindly reply.

Hello, For some reason the error does not persist anymore... Thanks for your help but I believe it has nothing to do with links. It jst solved itself somehow.. lol

Hello, I have a form and a subform in my database and I have linked 2 date fields in both of them and the program works the way i wish. But when I exit MS Access, It gives me an annoying message, MS Access has stopped working and is restarting. All the data entries in tables and forms are valid...

Hello, Let me try and paint a better picture, Form1 has one button 'btnCopy' Form2 has 2 fields 'Field1' and 'Field2' Now, By the press of 'btnCopy' in form1, 'Field1' and 'Field2' of form2 from the current Record must be copied to the next record in form2 itself. This is just a gist of the...

Hello, I have 2 forms. Let me call them form1 and form2. Both these forms have their tables as data sources. What I wish to do is: By pressing a button in form1, I want to copy the contents of the previous record in form2 to the next record in form2. Currently, when I tried this I am unable to...

Thanks for your reply, About the dates thing let me explain further. In the a table, one of the column have been set as Date. Now when the dates have been manually entered, say 30-Dec-10, 31-Dec-10, and so on. I should now be able to manually generate 4 months of dates without the user having...

Thanks for your reply, I vaguely understood the part about the query, but I had a doubt about the spreadsheet thing. The macro will be called in the VB code isn't it? If I want to create back up at all times, how do I perform the macro on every single entry. Should I do it when the user...

Hello, I sincerely apologize for duplicating posts. I just posted in the categories where it was related to. It may sound like a very amateur level project to you, but I am new to Access VBA and thus would appreciate some inputs. For your question, the project is due in 24 days time and thus...

Hello, I have been given a task to develop a booking system with Microsoft Access VBA for my project. Project Details: To create a graphical user interface database which would show, add, delete, edit details of the customers, companies, orders, products, staff, departments of an engineering...

Hey all, I am an electrical engineering student from singapore and am currently doing my internship in the the IT dept. of a company in Singapore. (for some reason god only knows) Well, hope to know you all better. I will throw out some queries I have for my work... so plz keep looking and plz...