Search results for query: *

Hi, I have transferred some tables to a my SQL Server 2008 backend and need to modify some queries. I was told to use a pass through query so im trying to convert the Jet SQL to T SQL but I don't know what to do with these iif statements. EXP_D...

Hi folks, I have a large Access 2003 database with a lot of forms and I am implementing an error logging system based on a code module i found online. The module checks all of the forms subs/functions to see if there is error handling and if there is none it inserts error handling code into...

Hi Folks, How can I add a line of code to every sub in an access VBA project. I need to add DoCmd.SetWarnings False to the start of each sub after the OnError. I really do not want to do this manually is there a quick snippet of code i can use in the immediate window to do this? Thanks in advance.

Hi, I'm having trouble booting XPe from disk 1. I have dowloaded the evaluation version which does not come in ISO format. When i burn the files in the Disk 1 folder to a CD it is not bootable. According to the instructions Disk 1 is a Windows PE bootable disk. Does anyone know where I can find...

Hi folks, I'm trying to import a lot of reports from one access database into another. I'm using access 2003 and i keep getting a "No Current Record" error on a number of reports and they will not import. I created a blank database and tried importing them into it but i got the same error. I...

Hi folks, I have been looking at some SSD Cache drives recently and I'm also trying to improve hard disk performance on our server. The server is a Dell PowerEdge T310 with 3x500gig SATA2 7200rpm drives in RAID 5, the Raid controller is a Dell PERC S300 which i'm told is software based. Would...

Hi folks, I have a chart on a form which I am exporting to jpeg with the following sub in a buttons on click event: Private Sub jpeg1_Click() On Error GoTo Err_jpeg1_Click Me.Graph1.Export "c:\DATABASE GRAPHS\Throughput_Vs_Target.jpg", "JPEG" Me.Graph1.Locked = False Me.Graph1.Enabled = True...

Hi, I keep getting a corrupt table. I have a front end and a back end. The front-end has one form with a sub-form. Sometimes seemingly randomly when entering data to the sub-form an error message pops up saying the record is deleted and all of the text boxes show #DELETED#. When i go into the...

Hi, What I would like to do is store a *.exe in an access database and be able to run it from the database. At the moment i'm running an *.exe through Shell() in VBA but the file has been deleted a few times and I've had to replace it. I figure that if i can store and run it from within the...

I'm not sure if this is the right place for this question. I have a query that shows if the word fail is in a list of certain records: SELECT CHILD.MODEL_NO, CHILD.TEST_TYPE, CHILD.LOT_NO, CHILD.PASS_FAIL AS fail FROM CHILD GROUP BY CHILD.MODEL_NO, CHILD.TEST_TYPE, CHILD.LOT_NO...

Hi, I have a form in Access that takes an awful long time to close. Any time I close the form it takes too long. Or when I change from design view to form view. But changing from form view to design view is instant. What could be causing this?

Is it possible to send email directly from access without using outlook? If so how would I do it? If not is there an easy way to avoid the security pop up where users are required to click "Allow"? Would it be possible to code a VBA email sender in Access? Hope someone can help! Thanks in...

OK, i have a combo box which lists some numbers. The numbers come from a table called specs i'm using a SELECT DISTINCT for the combo box so it doesn't show duplicate numbers. I have an if statement that checks to see if the number selected in the combo box matches a number selected in another...

If I use the navigation buttons at the bottom of my form to go to the last record, and then click the next record button it doesnt pop up the usual message say there are no more records! It creates a new record! I can keep doing this as much as i want it seems! I can't for the life of me figure...

I've done something wrong here it seems. The following code is giving me all "FAIL" results even when it should be "PASS". I want my subform to display pass/fail results in the column next to the x1 number but this code is only showing fail. What could be causing this? Private Sub x1_Change()...

Hi i have a pie chart on a form. It won't show up unless I click on it. Tried a requery in form on open event but no luck also tried the on load event but still nothing. Is there no way to have the chart visible when the form opens?

I have a master form with a subform in it. I have 4 fields linked between the two. The subform is set to datasheet view. I have a text box on my main form called RANGETXT this displays the range of values of the field x1 displayed on my subform. Now i need to write the range to the table that my...

I'm using this code with a button: On Error GoTo Err_email_Click Dim stDocName As String stDocName = "MONTH_REPORT" DoCmd.SendObject acSendReport, stDocName, "SnapshotFormat(*.snp)", "ssmallwood@maspac.local", "", "", [PM], "Hello, these are the PM's for the next month.", False...

How would I create a reminder to show how many of my records date fields are within 1 week or 1 month from now (in the future) I want to show a list on my form showing how many records due dates are within a month and within a week. Finding it hard to find info on how to do this, any help much...

I'm getting this error with this code: CurrentDb.Execute "INSERT INTO CHILD (Range) VALUES ('" & [RANGETXT].Value & "')" I'm trying to write data to a field on my table "CHILD" is there something wrong with this code? Thanks,