Debits And Credits (was Posted Wrongly In VBA Section)

Apr 4, 2007

I have a table that has debits and credits in two different columns along with other info.

as you can see from the attached Excel there is one debit for each credit. in some cases though there is one debit and 2 or more credits that sum up that ammount.

the common thing that Debits and Credits have is the project number.. but this alone will bring me all the entries!

how can i finf these lines? i have tried all sort of queries but nothing works.. anyone can help... its one thing i didnt think of..

thanks guys in advance...

View Replies


ADVERTISEMENT

Scenario-help (posted In Macros Too)

Aug 10, 2006

Hope I am posting my question in the correct place. First of all I am entry level user in access, but knowledgeable in excel. As I am working with data containing over 65,000 rows I decided to use access however I don’t know how create a function that will work give the same result as (vlookup) in excel. Scenario case: first column “Serial Number” contain a list of serial numbers, 2nd column will be fed manually or by a bar-scan, the third column should show the value of “1” if the value in the 2nd column exists in the first column else a value of “0” should appear

The validation formula in excel looks like: =IF(ISERROR(VLOOKUP(B2,$A$2:$A$65000,1,FALSE))=TRU E,0,1)

Serial Number Confirmed Serial Validation
141614661
141614662
141614663
141614664
141614665
141614666

Thanks in advance,
Tarek
tarek_habal@yahoo.com

View 1 Replies View Related

Help Needed Now Posted Twice And No Reply!

Jun 19, 2007

Hi all

I really could do with some assistance with this it may sound quite simple but for some reason I cant do this?? and its driving me nuts!

I have a column name [policy] and a column name [movement type]

the rule is you cant have a policy number and different movement types
you can have many of the same but not different and there are about 8 movement types

I would like to find all the policy numbers where there are two movement types using a query.

Any help would be really greatful

Thanks in advance

C
:confused:

View 14 Replies View Related

Help With Posted Browse Code

Oct 24, 2006

Hi, all! I really need some help from you geniuses here. I've never worked with modules and my coding from objects is very limited.

I need to create a browse button that will be used to select a file to import into my database, using a command button. I hope this makes sense. I was reading the post:

http://forums.aspfree.com/microsoft-access-help-18/how-to-link-fe-to-be-using-vba-76392.html?&highlight=browse+button

I am so limited in my aptitude for coding that I was totally lost reading this. I think that it is for relinking a database, with a browse functionality. Can anyone help me figure out how to adjust this to work for my needs?

Thanks!

KellyJo

View 1 Replies View Related

How Can I Use The Administer Section

Nov 17, 2007

I don't know how can i use the Administer Section in Ribbon bar
in access 2007 .
http://img413.imageshack.us/img413/2513/hhyt2.png

I know it's appear only with this file extension .mdb not with .accdb
and I don't know why also that's happen .

anyway , I will be thanks for anyone help me in this problem :(

View 3 Replies View Related

Hide The Detail Section

Jun 2, 2006

I currently use

Me!frmPatientLookupResults.Form.Visible = False


to hide a subform on my form that is in the detail section of my form.


Is there a way to collapse or Hide the Detail section of the main Form??

I notice that their is a property under the Detail section called Visible
with an option for Yes or No.. How would I manipulate that option through
VBA? I am assuming that is the option that I am looking for

View 3 Replies View Related

Controlling Height Of Section In VBA

Mar 27, 2008

My report has the Section's Footer.
Each time the section runs, it will take up a different amount of space.
I have already run all the code, to move all the different controls to the top (and be invisible) when they are not needed.
So to the best of my knowledge, I have no controls sitting in the lower part of the section.
The last thing I run is:
Code: Me.S123.Height = Me.S123.Height - 300
s123 is the name of the Footer SEctions. The idea is that it gets progressively smaller.
This is all running in:
Code:Private Sub S123_Format(Cancel As Integer, FormatCount As Integer)

All the other things work.
Here is a sample of it all..
Code:If Me.txt2 = 0 Then Me.a2.Visible = False Me.b2.Visible = False Me.a2.Top = 0 Me.b2.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End IfIf Me.txt2 <> 0 Then Me.a2.Visible = True Me.b2.Visible = TrueEnd IfIf Me.txt3 = 0 Then Me.a3.Visible = False Me.b3.Visible = False Me.a3.Top = 0 Me.b3.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End If

This runs through 8 different numbers.
as I said, all the other things operate properly. They get hidden and move.


Any thoughts?

Thanks.

View 3 Replies View Related

Add A New Section / Area For Scheduling

Feb 12, 2015

I need to make a random schedule every week. I have a new DB that I have attached and the current one being used that was built by some one else. The reason for building the new one is I could not figure out what to change to add a new section/Area for scheduleing.

What I have are 3 levels of auditors

Level 1 are the basic auditors which I will need 1 per shift per day
Level 2 Are operationl Auditors I will need 2 of the per week
Level 3 are management auditors and I need one of those per week.

When I get these compiled per week I will need to make a report to e-mail out.

I attached both DB's the old one to show what I need, and the new for a more stripped down and easier to update version.

View 14 Replies View Related

Comments Section, Modify Denied?

May 20, 2005

We have several users that access the same database. Is there a way to make it so that the users can add comments to the "coments" field on the form, but not remove any comments once saved?

View 1 Replies View Related

Sum Calculated Boxes From Detail Section

Sep 18, 2006

Hi
Got a form with a Detail section that can have any number of textboxes in it depending on the data a query brings back:

e.g.

QueryID Calculatedtextbox
QueryID Calculatedtextbox
QueryID Calculatedtextbox
QueryID Calculatedtextbox

The Calculatedtextbox has a DSum function, which uses the QueryID (another textbox).

I then have a footer at the bottom and need to sum all of the textboxes. Is this possible? Access doesn't seem to like it...

View 7 Replies View Related

Tables :: Add A Notes Section To Table?

May 1, 2013

I have made a table for prospective clients and want to add a notes section where I can add notes when I call them or they call me with the date. I have a comment section but thats not quite what I want. I would like them to be separated by date.

View 6 Replies View Related

Forms :: Scrollable Section Inside A Box?

Oct 22, 2013

I am looking for the ability to have a scrollable window inside of a tab.

My database is tabbed into categories of data.

One of these categories has more than the others.

I would like to create a rectangle inside the tabbed area which I can put the questions in but the box is too small, so instead of creating tabs inside another tab, id rather have a scrollable section inside in which I can put the questions in...

Is that possible?

View 7 Replies View Related

Form Section - Need N/A As Default In A Field

Aug 4, 2011

One of the fields on my form has ID field (can input either number, text, or both). It looks unprofessional when I am printing reports for ID because some are blank. How can I make that field to have automatic "N/A" when the field is blank? I put ="N/A" as Default Value but no use.

View 6 Replies View Related

Percentage Variance Section In Report

Jun 10, 2014

I'm trying to create a report that has three sections.

Section 1 = Planned Cost; Section 2 = Actual Cost; and Section 3 = % Variance.

I was able to build the first two sections easily with my query, but I'm having some trouble with the % variance part. Would I have to build that into the query itself, or is there an easier way to do it within the Access report fields?

Below I've included a mock-up (drawn in Excel) of what I'd like the Access report to look like.

Also, for reference, this is what the query used for my report looks like. Note: The original raw data looks a bit different, but I used a crosstab query in order to get the months of the year to appear horizontally as fields. (That's how I need my final report to look.)

View 10 Replies View Related

Having Details Section Stretch Vert And Horizontal?

Feb 27, 2006

I tried searching, to no avail. I've attached pics to represent my issue a bit clearer. I have a form that I want to be my switchboard, but my clients all have different resolutions, and this is where I run into the problem. I want the switchboard to not only be maximized, but appear maximized.

Here is the design view: Linkage (http://www.martinaustin.net/images/issue_design_view.jpg)
Here is the form view: Linkage (http://www.martinaustin.net/images/issue_form_view.jpg)

I want the date and bottom line to always be at the bottom. This works fine by simply using form headers and footers. The issue is that the Admin button will appear near the center (vertically) when viewed on a computer with high resolution, instead of just above the bottom horizontal line as I intend.

Does anyone know of a way to fix this?

View 1 Replies View Related

Reports :: Detail Section Randomly Highlighted

May 18, 2015

when i generate a report i intermittently get a page that has the detail section highlighted. The report generates an invoice for each customer selected, a new page for each invoice with a repeating header on each page. I have used the vba to some of the formatting on the page. Usually there are between 20-40 pages generated with each report, or there is an option to print just one invoice. I get the highlight on 1 page on some set of invoices, and other everything works fine.

I can not for the life of me figure out what variables are causing the detail section to be highlighted. Does not repeat on a specific customer, place in the report, or any specific that i can tell. What settings/variables/triggers/events would cause the detail section to become highlighted blue.

Right now i can generate the report, see a blue page(usually after its printed), and the regenerate it and its not there or on a different page. The invoices uploaded are for the same person generated right after each other..

View 3 Replies View Related

Reports :: Suppress Fields Or Section By Criteria

Aug 29, 2014

I have a command button that opens a report with a where filter. The report has a main section and a detail section. Its a Organisation and its Contacts. The Contacts are in the detail section. How can I suppress the detail section (and a label) if there is no records to show in the detail section?

View 4 Replies View Related

Forms :: Refer To Detail Section Of A Subform From Another Pop-up

Jun 29, 2014

I have a 'master' navigation form called 'NPYWC'

On it, there is a subform called 'patient' - this has a number of subforms in the detail section (Linked on a one-to-one key).

When the patient form loads, I hide the detail section until a user either

A. Finds an existing client record or
B. Clicks the 'ADD NEW' button

The ADD NEW button opens a separate (pop up) form where the primary patient information is gathered. When the user clicks "Save" on the pop up, my VBA script ...

A. Creates all the one-to-one relationships that are required.
B. Updates the 'Find Patient' field to the newly created patient number
C. Finds the new record
D. Un-hides the detail section (This is what I cant get to work)

I have tried a number of things. The latest being

Forms![NPYWC]![NavigationSubform].Form![Section].[Detail].Visible = True

The rationale for hiding the detail section in the first place? The answer is twofold.

1. If the user simply creates an new patient, the three actions (A, B C above) don't always run/display the data properly. (Im not sure why? ) The pop up form seems to be a good working solution for me.
2. My users have a tendency to change data on the default patient. I have tried going to new record, but then they add new (often duplicate) patient records.

View 3 Replies View Related

Reports :: Get Each Image Per Row At Report Details Section

Jun 16, 2015

My table structure is

id photoPath name
1 C:a.jpg A
2 C:b.jpg B

How to show all image per row at report details section in a report like

ID Image Name
1 Here Image of A A
2 Here Image of B B

View 11 Replies View Related

Reports :: Grouping And Sorting Without Header Section

Apr 10, 2015

What I wish to achieve is to create a report that groups and sorts without the need of a header section as it is taking up to much space cascading :

----
----
----
----
----
----

rather than :

---- ---- ---- ----
----
----

---- ---- ----
----
----

I basically want it not to cascade but do the exact same thing as it does inside its own header. (We need to dramatically cut down the page amount as a delivery schedule is printed out daily and could do with the page count around 10 rather than 50 ).

(Links below)

What It Looks Like ....

What I Want ....

View 2 Replies View Related

Modules & VBA :: Add Different Header In Each Section Using Automation To Word

May 14, 2015

I have programmed a letter using automation to Word VBA. The letter works like a mail merge so it might cycle thru several records when it runs. I've separated each letter in the document with a section break. I'm having a problem with the header. I've successfully added a header, but when it moves to the next record, it replaces the header in the entire document with the current record. I want each section to insert data from that record. How can I fix this? Below is a sample of my code (note: the linktoprevious doesn't seem to work either).

x = 1
'Create Header
With ActiveDocument.Sections(x)
.Headers(wdHeaderFooterPrimary).LinkToPrevious = False
.PageSetup.DifferentFirstPageHeaderFooter = True

[code]....

View 1 Replies View Related

Reports :: Conditional Hide Section - No Value In A Control

Aug 7, 2014

I have master and child fields in my query, and in my report I have blank controls where there is no child record to the master. I'm trying to set the section (Group Header and Detail) to be invisible when there's no value in a control.

However, as soon as I introduce an If statement to the VBA in a report, regardless of the event I put it in, it just stops working completely.

View 1 Replies View Related

Reports :: Highlight Only Last Row Of Detail Section In A Report?

Jul 16, 2013

Is there a way to only highlight the last row of the detail section in a report?

I tried the following code in the "Format" but could not get it to work in Access 2010.

If Me.ClaimStatuses = "Total Potential Recoverable" Then
Me.Section(acDetail).BackColor = vbYellow
Else
Me.Section(acDetail).BackColor = vbWhite
End If

Where "ClaimStatuses" is the control text box and "Total Potential Recoverable" is the value I want to equal so this row which is the last row will be yellow.

View 6 Replies View Related

Reports :: Hide Section On 1st But Show On Rest

Mar 22, 2013

I want to add a section to my report and control the visible value based on page (1st, 2nd, etc...)

So:

1st page show 'Page Header' which has lots of detail, but dont show 'AccNum.Header' section.

2nd, 3rd, etc.. don't how 'Page Header' as I don't need lots of detail, but show the 'AccNum.Header' as this has customer name and Invoice numer, which is enough header information of all the rest of the pages.

Tried using 'On Page' and logoc aroung [Page] but no progress.

View 2 Replies View Related

Report Header Section Size Limit

Nov 23, 2011

I am creating barcharts in the report header section but i think there is some size restiction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to do that .

View 2 Replies View Related

How To Get Rid Of Empty Space In Detail Section Of Form

Mar 13, 2014

I made a form with a subform - in the form header it just has the title, in the details it has details about level 1, then in the footer it has level 2 with all records assigned to level 1's ID. My problem is in form view the detail section takes up half the page, I only need it to take up an inch or so. I tried dragging it in design view and it seems to work in design view but once i switch to form view it still takes up half the page. I also tried changing the numerical height for the detail section in properties but it wont change.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved