Search results

I would like to password protect records on the form that have already been entered, not new ones. Essentially, if someone changes the company name on an older record, I would like to have a Msgbox pop up. But only on completed records.

On my report I have the following text box: =Format([Quantity],"Standard") & " MMBtu per day" When it prints out Quantity has two decimal points like this: 50,000.00 - I want to remove the 2 decimals. How do I do this? Thanks in advance.

I have a form that refers to another table of dates. It looks at this other table and figures out have dates are in between a Start Date and End Date. I have it so they are counted using the DCount function. Now I would like to list the dates in a text box in this format. 10/20/2001...

Oops sorry, wrong forum. Does anybody know this anyways?

I have a few labels over top of a subreport. If the subreport is blank, I would like to hide the labels. I tried IsNull(Child) = True then lblDate.Visible = False. Didn't seem to work. Any ideas?

I meant subreports.

I doubt this is possible. I have a report with 2 subforms. They basically have the same type of info in them. Is there a way take the results of both subforms and group them together. Perhaps creating another subform or something?

I have 2 Subreports that create one report. They basically have the same info in them, just a different way of retrieving it. Is there a way I can start one subreport directly after the last one finishes? I dont want a big space in between.

I am trying to build a query based on 2 tables/forms. My first form "Companies", has 2 check boxes. One for Canadian Currency, one for US Currency. These are automatically sent to another form where the transactions are done. On this other transaction form. There are 2 more checkboxes for the...

I am working on a system where the only way you can get a company's name on the confirm report is through a combo box (supplierID, suppliername). I have a buyer and a seller (both in combo boxes) seperated by an "and". I would like to create it so there is no spaces. If I use a text box, I just...

I have two text boxes seperated by a label with the caption, "And". Is there a way to have the label always come immediately after the first text box. So basically it moves when the text box is larger.

I know I need to add some code, but I cannot get anything to work properly.

I have a report that is generated from a query. Basically, you enter the company name on a form and it creates a report that gives the totals for the month. What I would like to do is, if the Supplier Name is not selected, it will generate the reports for all the suppliers.

Is there a way to find out ,lets say ,how many Januarys have passed between two dates?

I have two text boxes on a form. One is start date, the other is end date. I am using DateDiff the figure out the difference between the two dates in hours. Only problem is I need it to add an hour for October and subtract one for April to account for Daylight Savings Time. Any ideas?

Instead of actually deleting a record, I would like to have a button that takes the record mentioned (based on DealID) moved to another table which keeps track of Deleted Records. Do I need to run an append query. How do I get only the one recorded appended and not the whole table. Thanks

I have a form based on a table that I would like to lookup any records that are similiar to the one about to be saved. I know I need to creat a string a then most likely a DLookup to look for the values. But I am having troubles with the syntax. The fields are Quantity, Price, SupplierID, and...

I have a report that is based on a query. I just found out that I need to have an invoice number depending on how many times the report is accessed. Once the invoice is accessed again it needs to recognize the final number of the last printout and go from there. Another problem is the program...

I want a form to keep count of a Deal ID field without using AutoNumber. So basically DealId = DealID +1 once the form moves to a new record. Where would I put this? I cannot seem to get anything but zero.

I have a form that several people use. If they begin to use the form and do not complete a transaction ( I have a save command button) it still saves thte data. I would like it that if they do not hit the save command button it does not record the data into the table. I know this is quite easy...