Search results

Gents, I have a report that has the combination of Main form and continuous sub form. In the sub form there are two fields that i am using the If statement. The If statement works fine but the result applied to all the entries in the subform, despite the condition field is...

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...

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?

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...

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...

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...

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...

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...

Hello. I have a case of calculation of addition and division, I need to show the result in a report as follows: Cat1=3 Cat2=4 Cat3=5 Total of Insp: 20 The calculation should do the following: Cat1 +Cat2 +Cat3 / Total of Insp. Should I do this in a query or VBA? Thanks

Experts, need help I have a report that has long list of items.one of the field is a link to the main form. the request from my user if the color of the font could change after i click the selected item, This is similar to Google when you have chosen something the font color change as...

Experts, need help here. I tried to do a multilple IIF, but the results always come out on the first one, how can i tie the conditions and each should act accordingly. Here is the code. =IIf([First of Codecat]=1,[AccessTotalsmuamaladate_By_Month]*0.25,[calculate]), IIf([First of...

Gents, Hi, I have the following code: Dim rs As Recordset Set rs = CurrentDb.OpenRecordset(MySQL) If rs.RecordCount > 0 Then rs.MoveFirst Do Until rs.EOF If IsNull(rs!Email) Then rs.MoveNext My problem that sometimes the record of the Email is repeated on the second line, the system seemed...

Gents, I have a report that shows (attached) the different of results. I want to know how access report can calculate the results as follows: Total of (1) = Total of (2) = Total of (3) = Total of (null) =

Experts, 1- I have a table that has 4 columns 2- I used a field in a form to locate the second column and insert into the filed. 3- The i created a unbound field to display the third column as Description. 4- the unbound displayed properly as per the table (3rd Column). 5- when i...

Experts, Im having a shutdown, because everytime my access program goes to the message : " Unrecognized database format......" I had to isolate the database (be) and repair it and copied back. I have no idea where the problem is , anybody knows how to solve this once and for...

Experts, I have done many subform inside main form and produce a report with the combination of subreport to main report. All in one page. Today ironically, I tried to do the same but shockingly , the system seemed to think that each record from the subform (continuous form) must have a page...

Experts, Im still having a problem where the data after update event ,sometimes did not stay updated, instead it stays in its original position. The code Im using as follows: If me.typeofentry = "new" then me.typeofentry = "old" What can i tell in vba code to ensure that after update event...