Search results

In the after update event of the field priority add some code something like Select Case Priority Case is = 1 dblA=1 Case is = 2 dblA=3 Case is = 3 dblA=7 End select Me.CompleteDate=DateAdd("d",dblA,Me.DateLogged) dblA is a double representing the number of days. I am sorry I do not...

Store the pictures in a folder outside your database. Store the picture path only, like C:\MyFolder\MyPicture.jpg, as a text field in your database. In the form, add an image control, when you have finished remove the path to the image and make it linked. In the current event of the form add...

I am currently making a service person diary. As part of this diary I would like to be able to pick a job with the record selector and drag it to another part of the service persons day. A little like the tab order mechanism on the form works. I am hoping to add the ability to logically...

According to Microsoft the filedialog methods are not supported in Runtime only in Full Retail product, they just hadn't told anyone.

I have been playing around with a few Access books on various ways to relink my tables on startup. The technique I liked uses Access 2002 Office Object 10.0 library FileDialog. Sagekey Runtime lists Office Object 10.0 library as being distributable. However, whenever i try and run this with a...

I finally got it to work like: rptDate = Format(Date()-10,"Medium Date") "WHERE (tblCResults.RDate)= # " & rptDate & " # " The date()-10 is going to be dynamic so this is only a testing phase to make the idea work first. Appreciate your input though, it helped me walk through this.

Thanks Pat I tried modifying my Where clause and that caused a syntax error, so I copied and pasted the posted code and that is giving a syntax error. I am still new to SQL so I am sure it is simple, but I can't see what is giving this error. I have broken the statement down line by line and...

I am trying to pass a calculated date to the SQL below. rptDate is the paramater I am passing. I have tried various arrangemnts of # " & to no avail. I am stuck on this. Me.RecordSource = "SELECT tblCResults.CID, tblCResults.RDate, " & _ "tblSalutation.Salutation, tblClient.FirstName...

I have a database which scans in some logos and other stuff for forms and reports. Currently they are scanned in to CurDir and stored as Tif files. I was thinking the user could damage these, alter these or otherwise muck about intentionally or not. This is not my intent. So then I wondered...

That was what I was missing. I tried to run acCmdUndo but that gave me an error.

I have a form for entry of name and address details on the form I have a go back button that closes the form. I have a function to iterate through the controls and if they are empty returns blnCancel. Currently my code on the go back button is Call CheckEmpty(blnCancel) If blnCancel...

This site is great, and has helped me a lot in many areas. I use a few similar sites depending on the question, as some have areas not covered by this forum. However, there are some areas that aren't covered anywhere - that I have found. Perhaps there is a need to offer training on a...

After some searching and discussion in various forums, I have been directed to sagekey runtime as an installation engine. Sagekey offers two runtimes one that operates with Installshield and the other with Wise. Has anyone used these products and if so which product Installshield or Wise...

I have a requirement to write data once directly from a form to a module. Once written to the module the data never needs accessing again. Anyone know how to do this?

I have a report which is based on 18 possible parameters, depending on other conditions in the report. I have a query which retreives the base 6 parameters, the balance is made up of allowable deviations. In some case upto 12 parameters are required for any given procedure. Currently my code...

I have a series of forms for collecting data. Each form builds on previous data entered. This all works fine in MDB format. When I convert to MDE and update form 2 with new data I get an error message that Save is not available right now. This is the code: If Me.Dirty Then...

Try Me.(subformName).visble=False in the oncurrent event of the form. In the onchange event of the combobox, make the subform visible property = true

Have you considered acCmdUndo

If you have TEFLON spray, apply it to your hair liberally, because this is the part where you will want to tear your hair out in clumps. The TEFLON will protect you from yourself here.... (just kidding, but only kidding a little bit). Some of us would need superglue...

I have been working away creating an application for my office, I am now ready to roll out after testing on my machine at work. My problem is that most of the sales staff are dinosaurs when it comes to computers, and the rest a smart alecs who would love to break the app, just to prove it can...