Search results

Thanks I will give it a try. Where exactly do you place the code?

Not sure if this is possible, but I was wondering if there is a way to may the records in a form read only after they have intially been saved. My dilema is this. I created a database for an apartment complex that you enter info into. foe apartments, thus rendering all of the paperwork needed...

It is checked. I am thinking it is the dpi setting of the printer that are casuing this problem. Not sure but that is the only explination I can come up with. Thanks for the input.

The problem seems to be the printer that I have at home. I am using a Lexmark All in oone and for some reason it will not allow me to have a righ margin of .25 in landscape it makes .5 and can not be adjusted. I can not figure out how to make any changes to the printer properties to make it...

I have a db that I originally crated in Access 2007, when I created it I used Access 2000 format so I could use it on other versions of Access. I have a report that works fine when using it on Access 2003, but when I view the report in Access 2007 the margins are messed up. I orginally created...

Since there was only one item in the subreport the across then down worked and produced the results I was wanting. I copied and pasted the actual function to a module and when I tried to run the query I get a syntax error when calling the function, saying invalid or missing item. here is the...

I have tried several different ways to get the function to work, but each time I get a syntax error. It may be what I am after but not sure since I can not seem to get it to work.

Not sure if this is possible, but Just wandering if it can be done. I have a report Movereport that has a sub report subreportTenants. The data are from tables that are related by movereportid. Well the subreport pulls names from the tenants table and can have up to 4 names with each...

Yes I did use the nz function. The Val() worked like a charm. Thanks. I appreciate the help.

I have a report that is based on a query. It Contains info from 4 queries. It has I Total Due a Total Paid and a Balance field. All are calculated fields. When I get to my report I can format the Total Due and the Balance Textboxes allow me to format to currency, but the Total Due will not...

thanks again for your help.

Yes. That is what I was looking for. I used the Query Wizard and that is how the query came out. Thanks. I myself was wonderig why they were in there but, I never thought to take them out.

I have done some searches and found out about creating joins and have almost achieved the results I want. I have 4 tables (Invoices, Labor, Purchases, and Payments). All are linked by Invoice number and all of the data is enter via a form called invoices and has a subform for all of the other...

I believe I have figured this out. I had to created three queries 2 which had outer joins to include null values and a third with the other fields I needed then I made a query based on the three and added the calculated fields. My next question is how best to proceed. To my next step. Any...

I have attached a sample of data with the table I am working with. What I am trying to get out of the query is this From the table Invoice I want to get the field InvoiceID, DateofInvoice, Property, and BillingRate. From the table Labor I want to get the total hours for each job tied to the...

Thanks. I use both Access 2000 and 2007. So i will check out the book you mentioned. Thanks again

Just wondering if anyone new of any books that contain examples of code, functions, syntax, etc. I would like to have a good reference that I could go to instead of searching the internet everytime I need to try something new. Thanks in advance.

worked great. Thanks.

That is one thing I have not tried. I'll give it a try. Thanks

I have a billing rate in my main report invoices, and i then have a subreport called labor which can have multiple entries that include hours. I am then wanting to use the billing rate from the main report to get a total sum for the hours times the billing rate. I have tried everything I can...