Search results

This is, I think, what I can't seem to figure out how to do.

Hi All, I have a query (qrypackage1) that collects individual records from a table (tblproducts). I use this query to display certain products together as they form a final packaged product. The result of said query can then be displayed on reports etc. The thing is...tblproducts consists of...

Spotted it - I removed the extra I from the elseIf, then what you suggested worked: IF Me.ComboBox.Value = "Option 1" Then If Me.TextField < 1 or Me.TextField > 10 then MsgBox "Error" End If ElseIf Me.ComboBox.Value = "Option 2" Then If Me.TextField < 11 or Me.TextField > 12 then MsgBox "Error"...

I get the "expected: end of statement" once the code reaches the Then in bold below. It's this kind of error that keep occurring. I can seem to get it to move on to the next IF. IF Me.ComboBox.Value = "Option 1" Then If Me.TextField < 1 or Me.TextField > 10 then MsgBox "Error"...

Hi All, I'm having some difficulty with an IF statement that checks if a text field's value is between a specified range of numbers, depending on the option of a combo box. There are two number ranges available, and I wish to check/validate according to a specific range based on the option the...

Hmmm..... this has always been the case whenever we print anything in Access to PDF. A 'Printing' window appears saying 'Now outputting to the destination etc....' and whizzes through each report page, then closes once the Pdf has been created. This is Access with Office 365. Thanks very much...

Thanks Gasman, This threw up an error "cannot open anymore databases" ...... After looking around I noticed that aside from the active form/record with the Report to PDF button on it, I had also got another form open behind this which I use to open/access the said buttoned form......I closed...

Hi everyone, I have a peace of VBA code that used to work, but now doesn't. Here is the code: DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "DT14_IQOQdoc", acViewPreview, WhereCondition:="[Doc ID]=" & Me![Doc ID] DoCmd.OutputTo acOutputReport, "DT14_IQOQdoc", acFormatPDF...

arnelgp's solution worked perfectly. I amended it a tad to the below, so if there was no hyperlink, it would ignore it and still render the page: If Not IsNull(Me.Ctlhyperlink) Then Me!Image243.Picture = Split(Me.Ctlhyperlink, "#")(1) End If Thanks very much for your help.

Hi Everyone, I'm trying to display an image in a report (once printed) by inserting a blank image control, and setting the source of the image control based on a hyperlink field. Me!Image243.Picture = Me.Ctlhyperlink But.....access stores the hyperlink as...

arnelgp had the solution - worked perfectly: Login form button code: TempVars!tvarUser = Me!txt_username.Value parameter when stipulating the user else where: user = TempVars!tvarUser Thanks very much

Hi everyone, I have a simple login form that checks the value entered in text box with prestored data in a hidden table. Once the login button is pressed, the code checks the user name matches one in the table, and if it does, the form closes and the database opens. All works well. What I...

Uncle Gizmo's suggestion solved the problem. Copying the records from qry1 and inserting them into the table that feeds form 1 has resolved the issue. I used his videos to guide me. Thanks everyone.

It is all records in the query that need copying, but only certain columns/fields from each record (as indicated above), then those records being pasted into the datasheet on form1 (as individual records)/entries).

SELECT tblUK.Name, tblUK.Surname, tblUK.Town, tblUK.Car, FROM tblUK The user has currently been using this code at the moment to copy individual fields/columns from the first row of the query - which works - but it doesn't go on to copy the same fields from the next record...

ApologiesI should have stated that the from is not always going to utilise this function, hence why it is needed as a button. There will be circumstances where the form will have data entered manually by a user, and other times when data could be conveniently pulled from qry1. So setting a new...

Hi guys, I have a question about copying records from a simple query (qry1) into fields on a form (frm1) in datasheet view. I wish to copy all records from qry1 and paste them as individual rows/records/entries in frm1 in datasheet view. The catch is this....while I want to copy all the...

Thanks Minty, The full, original code is: Me.Text1.SetFocus DoCmd.RunCommand acCmdCopy Me.text2.SetFocus DoCmd.RunCommand acCmdPaste It always used to work, but now, it suddenly won't. I just find it odd that the copy command would suddenly stop like that across the board.

Hi Everyone, I have seen many variations on this problem, but nothing that quite relates to my own, specific issue. I am trying to copy text from a field on a form and paste it into another text field on the same form. Both fields are standard text fields, from the same table. The VBA...

Seem to have uncovered my own error.... I was putting the code in the main report's On Load event, but moving it to the main reports On Format event, and setting the Details section to Can Shrink: Yes, and the subreport to Can Shrink: Yes has removed the subreport and blank page it leaves...