Search results

Hello , I ve made a macro so that every week a master excel file gets updated with daily data. these daily data are in individual excel files named 140610 , 150610 and so on .. depending on the date . Currently if in the folder there is the master file and 3 individual date excel files (...

Hi everyone! I have a word document with some drop-down and some text fields in it. I'm facing a problem when i want to delete some of the text fields while the document is still locked, as the drop-down field doesn't work unless the doc is locked. Some of the text fields are optional, to...

Hey , Please help if possible. i need to map cells from an excel file onto a pdf which is then used to create a pdf form of the format xdfx. how do i do this at one go ( is there some thing for a range of cells to be copied from excel to the pdf file . the excel page says this : Appx2...

Hi! I've been breaking my head over this problem for 2 days now and haven't managed to find a solution! please help.. I am attaching a sample db. The problem is that when I search by a field (eg. Technical Team Feedback) in the subform of the form being opened(search form) the "view all"...

Hi :) I have a db with 2 worksheets (which I am attaching). It has a simple macro based on a filter placed behind the "Submit" button. However when you click the button, you'll see that "sheet2" opens and closes very quickly. Even though you can't see it this looks quite bad. I want to make...

Hi!! I don't have much experience with macros and need help!!!! I have checkboxes in column G. The user can select as many checkboxes as they wish. Once he/she has checked all the boxes they want, the values corresponding to them in column A should be copied to another worksheet. eg.. just...

Hi! When I export a report based on the a query with a memo field in it, the formatting in that field is not carried forward to excel. Meaning that if someone has pressed "clt+enter" and the memo field has text in two lines, it appears as one in the excel file. I have to then double click on...

Hi! something very weird is happening in my db. I have 2 fields Product Code, Product Name such that when i enter the value of either one, the value of the other one appears on its own from the Products table. I have 2 entries in the product table, both with product name = name2, And product...

Hi! something very weird is happening in my db. I have 2 fields Product Code, Product Name such that when i enter the value of either one, the value of the other one appears on its own from the Products table. I have 2 entries in the product table, both with product name = name2, And...

Hi! I have a database which multiple users must have access to at the same time. I read online about splitting the database to allow that, so i went ahead and did that. In my database there are buttons to generate reports based on certain queries. After splitting the database for some weird...

Basically the data in a form should get saved only when the user clicks on the SAVE button. I have seen a lot of posts online about this but i still haven't got a clear answer. please help!

Hi! I have a database which already has a lot of data. However my I need to add in a record for Warranty ID (which is an autonumber field) = 29. How can i do this? Please help.. I don't want to delete all data and key it in all over again!!!

Hi! I have a mainform with a subform. The subform has a field called Reason Code. Suppose there are x number of records in the subform for that particular record. What i need to do is that if more than 30% of x have an entry of TBA in the Reason Code field, the claim should be rejected and the...

Hi! I have a subform with a field called Reason Code, which i want to make mandatory. I know 2 ways to do so: The simplest one was to make the field in the table as required. This works perfectly, but the problem is that message box that is displayed when the field is left empty. It says...

Hi! Basically I'm creating a database in which i have 2 fields called "Product Code" and "Product Name" respectively in one table each with a number of entries. What i require is that in the form if someone choses a particular Product Name the corresponding Poduct Code should appear on its...

Hi all! Basically I have a form based on a query. The form has a Subform. The problem is that when i click on the next button in my form instead of going to the next page of the form, it stays on the same page but points to the next record. what i need is that when i click on the next...

Hi! :) Basically i have a Warranty Claim System. In the main form there is a subform called Warranty Claim Details which gives the details for each claim. Each claim corresponds to a specific Warranty ID. So basically each warranty ID(which is on the main form) has multiple entries in the...