Search results

I want some guidance in regards to how should I export access form as a report to excel. I already have fields with formulas in it and here I have fields where I have written down the numbers, so when these numbers get exported to excel. Excel will be populated with with these numbers and all...

Okay here is my code, I had thread open awhile back. In regards of exporting main form and subform to word. Here is the code, I am still having problem with it. I can't seen to take export nothing or if I switch around dbs.close and rs.close, I end up exporting whole subform (meaning all the...

I have a query that calculates the 'amount of credit' depending on the draw down date (which is when they started circulating the loan docs b/w two parties). Anyways,, the question is how can I make two columns of 'amount of credit' instead of one. Because one of the team member is dealing with...

Exporting datasheet to word, how is this possible using vb. Actually, I do have a thread in Form forum. But, I think not a lot of people visit that place. Anyways, I have created bookmarked and used datavariable to export the data (by ansentry's help). But the only thing that it exports is just...

Okay, I searched prolly even hit my head over the keyboard several times to find something resourceful in context to what I am looking for. But I didn’t, if there is something out there and it didn’t appear during my search or I missed it by any chance. Then accept my apologies. Now here is the...

Okay, I searched prolly even hit my head over the keyboard several times to find something resourceful in context to what I am looking for. But I didn’t, if there is something out there and it didn’t appear during my search or I missed it by any chance. Then accept my apologies. Now here is the...

I created this database long time ago, but now my boss wants to import the contacts list from outlook into the database. Now, these lists will differ per user. Right now there are 6 users, who are using the database and they all will have different contacts lists. How can I import it in a...

I have a subform, which is in datasheet mode. In that subform I have a drop down menu (combo box), and then I have 3 different fields where the value will be written. e.g. Assets, Liabilities, and Equity. Assets and Liabilities will written down by the user, but Equity has to be calculated...

I am trying to create a cross tab query which will output the data for only three months starting from the recent month. I would want these months to be heading. However, I don't want to create reports over and over again. I want something, that will resolve the issue through parameters kinda...

I'm trying to setup a conditional input mask for the postalcode/zipcode field. Canada postal code input mask format "00000\-9999;;_" US Zip code format input mask format "L0L 0L0;0;_" I've setup the country field, so that CANADA, and USA are the only 2 choices from a drop down menu. I want...

I have financial table which contains list of End of year revenue titles. Since this combo box was suppose to be part of the master table so I made a joint query. Now there is one problem arising. Table and query and even the form is working fine. But in that combo list there are several titles...

I have this master form, under this main form there are 3 subforms, each subform is created from the same table as the main form; however, now the problem is that these subform are datasheet mode, I want to add as many field as i want to. But, one of the subform's entry is suppose to be...

Okay, m sorry to bring this topic up again! I have created this command button from tools that output the access report into word file. However, it prints all the record into word file, is there a way that it would print one record or selective record at a time. I mean, lets just say if I am on...

Hi, I have done my search and what I found was not sufficient enough for one of my query. It was for most of the fields but not for all. =Pmt((1+[Annual Interest Rate]/2)^(1/6)-1,[Amortization]*12,-((([Annual Rent]+[num8]+[num9]+[num0]-[Perc1]*[Annual...

I am creating a Financial Statement database and I am done with most of the stuff. Except for one thing that is holding me back, that is there are four columns and these four column has Rent info, monthly rent, yearly rent and share of rent. Since, these column would have as many rows as user...

Since, I wasn't sure in what catagory this post will fall into, I am posting it here. Hopefully, you guys will u/s my query. What I am trying to is I have one financial statment that I have created in excel. However, I am not a pro in excel, and even creating a template is not serving my...

UPDATE Tblfin SET Tblfin.Processes = "Active" WHERE (((Tblfin.Processes)="New") AND ((Tblfin.DateRecieved)<=30)); I need help in this query, what I am trying to do is I want to update a combo box where new records should be updated automatically and become active after a month. I know I am...

Is it possible to align list box somehow. I am trying to rightly align the numeral field and listbox is on the footer of a report. These values are retrieved from a query. Now, I am trying my best to align this numeral column, but I can't. Is it possible, or is there any other way around it to...

I am getting an error 'Run time error 2001, You canceled the previous Operation'. I don't know where I am makin a mistake in this code. I hope you guys will figure it out. Private Sub Form_Load() 'On Load of the switchboard check Jobs table for any uncompleted jobs Dim intStore As Integer...

I am trying to create a pop up calender kind of thing. What I want it to do is pick up the date from the 'follow up date' field and email it to me when my database starts. I know its an easy task, but for some reason after a long struggle I am still stuck with it. I can email the tasks using...