Search results

Hi Guys, Can someone check my code for me and point out where I'm going wrong? I have a table called Tbl_Salesman. It has 4 fields Salesman RSM Salesmans E-mail RSM E-mail. I have a combo box on my form that allows me to link these in so that the user selects the Salesman and an e-mail...

Thanks, I was missing the ('). Opening a form from a record makes sense in my Database. The report lets people see all outstanding records. They can then click on a single record on the report and go into the form to update. It might be wierd, it might not be normal, but it works for what I...

I'm sorry, I'd like to disagree. I have a report that shows all outstanding records on a form. This is run from a query. I then have (on multiple times) use the aforementioned Docmd to open the specific record on a form when you click on the record on the report. This allows you to go...

Hi Guys, I'm having a bit of trouble with a Docmd.openform thats not working. The code I have is DoCmd.OpenForm "Frm_Enquiry B Log", acNormal, "", "JAPAN_REF=" & Me.JAPAN_REF I just get an input box asking the value of Japan Ref This is placed on the details property of the report. It...

Hi Guys, I'm putting a button on my database to open a link to a web based database. I have two problems here. 1) The web based database doesn't really work with IE and needs Chrome 2) Work decided to move over to a Virtual desktop, so I can't use the "Shell......." method as the local...

Thanks CJ. I'll sort out the lookup and I'm pretty sure i'm on track with the combo box.

Hi Guys. I have a two tables. The first has Salesman and RSM. The second has a lookup to select the salesman from a drop down. How can I get it so that I can do another lookup field that returns the RSM of the salesman chosen? I want to create an e-mail button that will e-mail the salesman...

Don't worry guys, I've figured it out. My Blanket Agreement Number has the format "SGB"# The first record I had is SGB1. Once I change my file name to FileName = "SGB" & Me.[Blanket_Agreement_Number] & ".PDF" it works. This has highlighted another query. If I export this to Excel for...

Hi Guys, Its still bugging at the Hyperlink stage Private Sub Command45_Click() Dim FileName As String Dim strpath As String FileName = Me.[Blanket_Agreement_Number] & ".PDF" strpath = "I:\21.Processed Shikomi Forms\" & FileName Application.FollowHyperlink strpath End Sub

Hi Guys. How can I open a file using ME.[Blanket_agreement_Number] from one of my tables? Am I right in thinking it would be along the lines of: Dim FileName As String Dim strpath As String FileName = "ME.[Blanket_agreement_Number]"&".PDF" strpath = "c:\Filepath\" & FileName...

Thanks Thats what I was after!

thanks I'll give that a try

Hi Guys, Is there a way I can make a query for the following: Criteria Month([end date]) - Month([Today])=3

Hi Guys, I have a long table that I want to split into multiple forms. The first form will be my register form. I then want to make smaller amendment forms. The thing is though, I want to make a click button that opens the form, but as the two forms are on the same table, I want the...

Thanks guys for the responses. I still can't get mine into ACCDE, so instead I unchecked the options to show the menus and ribbon from the settings. He then found a way around that, so I also used the turn off the ribbon code on the load event of my login screen. He now can't find a way...

Hi All, I have a user who has discovered design view on my database. He is a user and so needs to be able to access the database. Is there a way to lock my Form's in Form view and disable design view until I need to use it? My Database won't publish into Accde for some reason and I've...

Thanks for that!

Hi, Just had an "I wonder" moment. I have a form that stores information on requests from outside sales. Once we have completed the request, I have a button that will e-mail confirmation from Access to the salesperson. I also have a field that is effectively [Date advised] so we can keep...

Brilliant!! Thanks guys, thats me done!

OK, Thats worked. As per my original post, is there a way that I can get the query to ask for the two dates, as the date range will always be moving and I won't be the person running the query? Ideally, when the query is run, I would like two pop up boxes to appear and ask for date 1 and date...