Search results

OK, been a long time since a post on here....... Working with an older app I have dealing with photos... I want to have a button that the onclick event will be the same as if you right clicked the image, picked properties, summary, advanced..... this will show the EXIF info..... Thanks!

If the email address is visible in the form... (if not make a textbox for it drawing off your table) then just insert the textbox after your format.... DoCmd.SendObject acSendReport, Combo38.Column(2), acFormatPDF,Me.EmailTO, "type = '" & Combo38.Column(1) & "' AND IDquote = " & idquote...

Well, if I am following what you are saying, I would not write any code to the button...except maybe a requery... Your subform is based on a query that includes "NGO, GOPC and Donors" in the criteria, put the path to the value on the unbound checkboxes on your main form. Hit your re-query and it...

Definitely put your ticket prices in a table. I would put the calculations in a query, not directly on the form. Like a field.... Sales: [TicketCost]*[TicketsOrdered] This way you don't need calculations on the form or reports. Also something to think about..... When I am using calculations I...

You might try something like this...... Private Sub Form_Load() Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000 End Sub See if that does what you are looking for... then play with the numbers.

Yes, I think you have hit the answer... And "You can't" was what I also remember :) At this point it's immaterial if I put a SQL backend or use an Access backend... What I was trying to do was to connect to that backend, on an internet site, from an Access frontend OFF the internet. Still seems...

Been trying to find some reading on this but this one is a little new to me and not sure what direction to go.... Let me explain my DB and what we are trying to do.... The App is to record job applicant information. That part is no problem, the db has been done for a couple of years and used by...

Having a problem that I could not find anything on here about... Maybe I'm looking in the wrong place.. or phrasing my question wrong...... But, have a new computer here that someone is trying to open a front end to an app I made a few years back..on Access 2002 or 2003.... Getting an error...

OK........ Update to this problem...... Have both Access 2002 and 2003 on this machine... Removed and reloaded both versions, suspecting something corrupt in the install... Now, I can view the linked table manager if I open the frontend with 2002, but no tables show if I open it with...

"Is it possible to have a field which would allow a different calculation for each material?" Check into a "if....then" statement, or a "select case".... either should enable you to choose different calculations depending on the value of the "materials" field.

OK........sounds like you have it... a form on the second level reviewers front end thats source is a query that only meets the criteria for them.

Check this link....might answer you..... http://office.microsoft.com/en-us/access-help/i-see-error-displayed-in-a-control-HA001181448.aspx

First, sounds like a little more explanation of "get rid of our emails of accounts" means.... but you will probably end up with a split DB. And your forms on the "second level" reviewers front end would open to meet the criteria that applies to them.

Dont use switchboard, so its no problem...... Yea, strange.... Everything works..so it IS actually linked.... Just doesn't want to show it.... Might be the reload I had to do... I'll reload Access next week... see if some corruption happened there.....

I thought I had found it....but..........

Checked on unchecked on both of those makes no difference............

Well, Bob, I didn't even know you COULD set the tables to be hidden...... But, its in 2003...looked under the general tab in options on the BE..... No box to be checked or unchecked................ I've narrowed it down a bit...... had to reload XP on my machine last week...then Access...

Having an odd problem..... Maybe I haven't worked with any of my DB's for a few months and just having a brain freeze ....but....... Have a split DB...works fine, no problems... When I open the front end and click on "Tools" "linked table Manager" there is nothing there......... The tables are...

If you got the code here, it should look something like this...... Sub AuditTrail(frm As Form, recordid As Control) 'Track changes to data. 'recordid identifies the pk field's corresponding 'control in frm, in order to id record. Dim ctl As Control Dim varBefore As Variant Dim...

Well, ALL of the accounting systems I have worked with store an invoice amount...there are too many variables and instances that may arise, none of which are date dependent....You store a calculated field for "Historical" purposes when needed.... Yours on the other hand will not change...