Search results

Gents, Im confused one day my splitted database work fine with multi-users and suddenly the multi users features stop working. 1- i have given all full control 2- I update the access program The access programs was on a network server. If i take the access program out of the network server...

Thanks a million pal. It works

I have two reports from two different tables with results of sum of numbers of each and i need to add them together . Any suggestion?

Dear Namliam Thank you very much for your quick response. I did do the NZ , it worked in the main form, but due to continuous form status, i split the the form into mainform and subform, the months are in the subform. With the same code of NZ, im getting blanks. Pls help

Hi guys, I know and feel that my question is soooo stupid, but unfortunately i dont get it. I have in a sub-form a field called : Total Qty I have 12 fields for months, JAN,FEB,MAR....... and each month field has a value 1, 3, 4 What I want is the system to add those values and record it...

Hi guys, Thanks for the interest. I should have been more clear. If i use the same site on all browsers, the site comes out perfectly. The only problem i have is when i created a button in my access program to go to the site, it says that such site could not be found. Even i use the same site...

Dear The Doc Man Thanks for taking my enquiry, poor guy Whiyshire, nobody looked into his problem until i came along. BTWI have open my case in another page, but what i saw the poor guy had the same problem, I didnt see the date. Anyway, i just checked my computer , it is up to date. Still I...

Hi, Yes it happened to me. All of a sudden, the hyperlink stopped to do its job. Im still waiting for help

Gents Thankyou for your response 1- I confirmed the site didnt change 2-Yes I took the same site and i was able to open it in all browsers

Experts, in my ACCESS form i created a hyperlink field to go to a specific page in the net. And it was working beautifully. Surprisingly. after few days later, the hyperlink field stopped going to the page. Instead, it gives a message saying that it cannot go the specific page. I dont know...

Dear Arnelgp Thanks for the prompt reply, can you be more clear how to make the update query. Im not that expert in this matter. Thanks

Gents, I have an access program having all the tables and queries and forms and subforms. I made a copy of the database and sent to a client to fill in the fields. After all the fields has been filled in, i needed all data from the copy database to be transferred to the original database...

Colleagues, MS Access 2016, I have a hyperlink field called LINK, and in the form the address is entered into the field. I got through VBA, the LINK address appeared in the email and also hyperlinked, but I cant understand why it didn't go the address, it did say " CTRL+Click...

Dear Sir, I have a program that create an email, and my attachment is attached but the attachment came out as an image, i cant open the attachment. How can I attach the attachments lie any attachment in the email attachment. So that we can open the attachment when click twice. Brgrds...

DBguy, what can I send you. Thanks. Isladog. I never tried the Dsum. Can I have see example that I can replicate with my data. The chart that I'm trying is in the footer. Thanks very much

Thankyou for your prompt reply. I appreciate it very much. As a matter of fact, yes I tried to do the sum and division in the query, but because of its is crosstab nature, the report is not seeing it as a data or value. Everytime i tried the sum and div in query I get the message not aggregate...

Experts I have created a crosstab type of query. and I have created from it a report. wthin the report i created extra unbound fields with sum functions and division function. next i wanted to created a chart to display the results from the unbound fields and no results. anybody tried the same...

Experts, I think this is a very simple question but nothing works for me. How can i tell the report not to count repeated numbers? I did declare to hide the duplicates and still it is counting. I tried to defined a specific field =str(Count(ref)) but still it is counting as if it is...

Thanks .I will try

gents, I have a report that has an IIf statement (unbound field) as follows: =IIf([First of Codecat]=2,[AccessTotalsFORWARDTO]*1) =IIf([First of Codecat]=3,[AccessTotalsFORWARDTO]*2) =IIf([First of Codecat]=0,[AccessTotalsFORWARDTO]*0) the result came out perfectly, but when i want to...