Search results

Hi we have a database frontend/backend and am moving the backend to an SQL server. This seems to have stopped the next and previous button working on the form although the add new button still works. The form is opened to a specified record via and another form using this code Dim...

HI I have this in the criteria of a query field name priority IIf([Forms]![frmTRinput]![Text103]=[priority],[forms]![frmtrinput]![text103],[priority]) [Forms]![frmTRinput]![Text103] will be any number 1-7 depending on user input. Priority is in a table and might have any combination of numbers...

How can I transfer a querys results to MS project via an on click event. At present I transfer to excel then link project to excel but there must be a better way.

The situation: We have a split Front end back end database which is used to raise Technical Requests on our design engineers, approx 30 users, some are management. I have created a method that uses MS Project so the managers can easily see via a Gantt chart what his team has on and how to plan...

Hi Im using this VBA code to insert a drawing numbers for our engineers. Private Sub Form_BeforeInsert(Cancel As Integer) Me.Text505 = Nz(DMax("MyCounter", "tblAttributesGA")) + 1 Me.txtGADrawingNumber = Nz(DMax("MyCounter", "tblAttributesGA")) + 1 & "-01" End Sub At the moment the form will...

I have the query below working but I need to modify it to only calculate fields where the Approval field in my table is null or empty, I have tried adding the Approval field to the query but the DSum just ignores it, I think the Approval field has to be part of the DSum critiera RunTot...

I have a select query that sums the yes/no data from a table by month and year, Im only interested in the yes (-1). Now I need to use this data in a chart but as it sums, all the numbers are negative giving for example -7 for june and this makes the bars on the chart go down. How can I get it...

How can I rewrite this code: If DLookup("[logon]", "Employee", "[id] = 1") = Environ("username") _ Or DLookup("[logon]", "Employee", "[id] = 2") = Environ("username") _ Or DLookup("[logon]", "Employee", "[id] = 3") = Environ("username") _ Or DLookup("[logon]"...

I’m creating a database of time spent weekly on a project by an engineer. I have a multiple items form “frmhrsweeklyinput “ with bound textboxes from a query "qryHrsWeeklyInput" in the detail section of the form ”task” “week1” “week2” “week3” “week4” “week5” then at the end I want to add these...

Im trying to update all the null values in my table (tblHours2010) to = 0 Columns in the table are week2 to week52 How would I rewrite this so I dont need to run it 54 times? Update tblHours2010 Set week2 = 0 Where week2 Is Null

Im using the method described in Article ID: 290136 (http://support.microsoft.com/kb/290136) to create a running total in a query, this is work great until the years changes in the data and it starts over again. How can I rewrite this code so it will give a running total over 2 or more years...

I’m trying to create a chart in a report that shows how much time each team in our department spends on a task. The chart is yearly split into months showing each team in each month. If I set my query for the chart like this: SELECT qryMNonEngRptTm.SumOfDuration, qryMNonEngRptTm.Dept...

I am trying to do something I first thought would be simple, Doh! I want to open a form to add a new record to a table, (Done that) When the form opens I want certain fields already filled in with data from a query. What I have is: Table with Name, logonID & dept Query that returns the Name &...

Hi Im using sendmessage as a public function to send an email, I'd like to let the user set the importance of the message. Iv tried changing the code where it states the email importance to: .Importance = ([Forms]![frmTRupdate]![text101]) Text101 is unbound combo on form TRupdate with...

Hi Im using “sendmessage” in a module to send an e-mail with an attachment. The code Im using is copied from HERE The code in full Sub sbSendMessage(Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient...

Iv got a form with two combo boxes (combo0 & combo6) depending on whats in them I want command buttons to be visible or not. Now the first 2 IF statements work fine but the last 2 ones with the added OR statement aren’t playing ball. Im sure it’s a simple fix but I cant see it. Thanks...

Hi I have a table with these fields in it , “job number”; “date in”;”required date”; “completion date”. I need to make a report to show, total Jobs in, jobs finished on time, jobs finished late and jobs outstanding. So I’ve got 4 separate queries · qryJobsIn · qryJobsOnTime · qryJobsLate ·...

Hi First post, What Id like to do is Drag an Email from Outlook onto a form in Access (in a frame or something) then send an Emial notification via Access using the “Docmd.Sendoject” command including the dragged Email. Then when the recipient receives the email notification from Access they...