Search results

I am using DMax function for my custom autonumber I just realized that when using this in a multi user environment, I am getting duplications. This field is not the primary key, and I am using this as a group ID and cannot set it to “no duplications” My form also has a sub form, and when...

Since the form has a sub form, and when entering the sub form the record get saved, I added the following codes. Can you please check if this is the right way? Thanks Joe Private Sub Form_AfterInsert() If IsNull(Me.OrderNo) Then Me. OrderNo = DMax("OrderNo ", "tblOrder") + 1 End If Private...

I like your idea of trying 10 times. However, would you have such a loop code that I can use? Thank you Joe

Hi everyone, I always used a custom AutoNumber (DMax function), until recently I realized that a lot information is not correct. The reason is, because of the duplicated auto numbers. The fist thing I did is a search here. This thread is exactly my situation. The duplications are happening...

I have a report that has 5 sub reports. Each sub report can have its own sub sub reports. The size of the sub sub report will never be more then 2 inches in height. The sub report and its sub sub reports always have to stay together. If not, start a new page. I can’t set the main report to...

I’m sorry, I can’t find anything related to my problem. Thanks Joe

Att: Neil, Yes, you are correct. There is no record in the sub table. However, I’m not clear on where I can add your NZ() solution. Every deed can have multiple mortgages. However, in some cases a deed will not have any mortgages. I tried to modify the query and the Function NameString but no...

I really can’t figure out why I’m getting an error when running my report. The report is based on a query, and when running the query everything is fine. I have attached a sample DB This DB has only 1 query and one report. If I remove the fields “Mortgagee” and “Mortgagor” from the report...

Thanks Is there a way to have this done in code (VBA)??

I have a report theta I would like to print to a specific printer, but I don’t want to select the printer from the dropdown each time I print this report. Can anyone please help me with this? Thanks Joe

I have a DB where I keep all my items I have a memo field where I keep the HTML code. I’m exporting the table and uploading it to the web. At the moment, I’m using Front page to edit the HTML code, then I’m pasting it into the memo field. (This is too much for me) Is there a way to have a...

I have been trying to solve my problem for months and being sent from one web site to another, until I got to here. I made a search all this news group to find an answer to my question. Unfortunately, I couldn’t find the answer that fits my needs. However, I see that most people that post...

I'm creating for my manufacture company a small DB that will have multiple warehouses. We transfer a lot from one warehouse to another. Does anyone know of a sample DB with multiple warehouses? I also would like to have the production part built in. which means, I'll have a table where I keep...