Hello All,
Is there a way to use a form that was created in Excel in access. What I am trying to do is Create a Report that will fill in the fields of the form that was created in excel. ( Need to try and keep the layout of the form created in excel.
thanks for any info i can get on this...
I am trying to print a report of all records in a table but only print the records that have the required result from a certain field..
want to do this thru code.
Like "*" & [Forms]![Transfer]![SearchFilter] & "*"
The above expression in the Critera in the query works good for finding text. but when i enter numbers it crashes any ideas.
I would like to use the last input of a field as default to ease the repetive typing. example. typing in Purchase orders. you may have 12 lines on the PO and each line will be a record but the PO will be the same. I would like the po to auto fill the field until I start the next PO then I...
Private Sub Part__Exit(Cancel As Integer)
Dim varPartDescription As Variant
varPartDescription = DLookup("PartDescription", "Inventory", "PartNumber = [Part]")
If (Not IsNull(varPartDescription)) Then Me![Description] = varPartDescription
End Sub
In the above...
Hello All,
I am trying to Get a value from a Field in a Previous record. Could someone please give me a boost in the right direction. Not looking for a complete solution but a Nudge in the right direction..
Thanks Margah
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.