Search results

In design view for the form, select the control that contains your price, in the property sheet select the Format tab, you will see Decimal Places where you can set it to 0 and it will not show the decimal portion. But, if you don't always want the decimal to not show except when it is actually...

It doesn't work with Dlookup, it has to be in the underlying record source so try adding it to the query. As far as displaying as an icon in the form, go into design view, select the control and in the property sheet data tab, you will see Display Type, select Content.

Instead of using the attachment data type, use an ole object. You can directly reference the Ole object in form and report controls.

You can attach it here, look for the paper click in the formatting section above where you type your message and you'll need to zip it up. Make sure your clicking Post Reply, not the Quick Reply.

If you could pare it down to just the table (remove most records) query form etc. you are working on I could better see how to accomplish your goal.

Would you be able to attach the DB?

Here is a way to do so: DigitsBeforeDecimal = CInt(12345.345) DigitsAfterDecimal = Right(1234.434,Instr(12345.345,".")-2)

What information is unique to table1 that is also stored in table2? If you don't have that you will not likely get good consistent results.

Maybe it just doesn't see the Alias ETD_Date as a date data type. Have you tried surrounding it with CDate()?

Have you reduced your query down to the point where you don't get the error? That should lead you to knowing what syntax is off. Also, for performing date math try using the DateDiff function. DateDiff("d",[Date Stamp],[ETD_Date]) AS Day_1

I'm a novice, but you should be able to create a field in the table on your SQL server as data type Blob or LongBlob and store the file directly as an OLE Object on your form.

Instead try Me.Refresh and if that doesn't do the trick try docmd.GoToRecord,,acFirst

Are you using a query and trying to set the column criteria's based on your forms selection? Or, are you trying to modify controls shown on a form based on the forms selection? And, it would be helpful to see your DB to get a better understanding why your using the search form. Thanks.

To your code add Me.requery: Private Sub cmdDeleteEmployee_Click() On Error GoTo Err_cmdDeleteEmployee_Click DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord Me.requery Exit_cmdDeleteEmployee_Click: Exit Sub Err_cmdDeleteEmployee_Click: MsgBox...

Are all the controls bound to fields on the same table or are you using subforms on each of the tabs that have a master/child link? If the later you may simply need to add an Me.requery to cycle the records.

Access is smart so if it looks like a date with time Access will allow you to concatenate the two fields. I added CDate just to ensure it is stored as a Data Type Date. Cdate(#6/27/2013# & " " & #5:00 PM#) This will result in 6/27/2013 5:00:00 PM.

On the surface your code looks good but I'm guessing you either have other code running in other events that is modifying the record prior to your deletion attempt creating the violation or you are trying to delete a new record that violates your data rules. Try adding this to your code: If...

Your welcome. Glad I could help.

For bound controls that you would like to automatically populate based on information recorded in another control you can take advantage of the After Update event to perform the calculation and assign the value. In the Text128 After Update event add the code to calculate the VAT and Total: If...

No question really can be considered an easy question. Here is a function to return the last Thursday of the previous month: Function GetTh(dtDate As Date) As Date Dim LastDate As Date, WeekD As Integer LastDate = DateSerial(Year(dtDate), Month(dtDate), 0) WeekD = Weekday(LastDate, vbSunday)...