Search results

Hi there Yes. I have copied and pasted the code in to a module within my database

Thanks! BUT. I STILL am at a loss to get this work. I tried to create a query and change all appropriate names, nothing :( What I have done now is create a view on SQL Server where I draw in the two date fields I need. Connected this view in to Access then just created a query based on the...

Looks good. But how do I use it? :confused:

Hi Folks I need to calculate the number of days between two dates excluding the weekend (I am not bothered about bank holidays etc). I am trying to find out if applications made by people have been registered within 3 days. The initial date that the application has been date stamped is in a...

Thanks for that. BUT How in the heck does this all work. Obviously no code would be desirable. The method described as "Good" looks very nice but I couldn't work out what was going on. Sorry to be so thick on this :confused: Jools

Hi Folks OK, I found a nice little piece of code that would appear to do what I want. Trouble is I don't know what bit of the code relates to a form control, column etc The code is Sub Zip_OnExit(Cancel As Integer) Dim varState, varCity As Variant varState = DLookup("State", "tblZipCode"...

Since my post I came across this link (http://www.mvps.org/access/resources/downloads.htm ) which has helped with my working day/ weekend problems in my query. Slight problem! I kept in my original Datediff (see earlier post) just to compare the results of the datediff against the results...

:D OK. If I have to go the VB route, how do I do it? I have never ever done a query that uses VB and would not have a clue as to where to start :confused: Thank you for the help so far :D Jools

Hi there! I need to run some stats for my workplace that involves working out if applications have been registered within 3 days. How in the heck is this done :confused: I've had a browse through the forum and I noticed that VB seems to come in to it. Do I really have to use VB to work it...

Hi there I have a database that has two tables. Table 1 is called applications and table 2 is called contacts. Table 1 has two fields that relate (not through the relationships) to table 2. These fields are named thus: Officer and ContactTelephone Through a form I wish to be able to do the...

OK trying my best to figure out an append query but having little luck :confused: Hopefully can explain what I am after. I have a main form that has a number of fields two of which I need to match up in a where condition: ref and ryear. On this main form is a subform where the data from the...

Hi there If I have a form open on a particular record I would like to transfer the text from that record in to a merge document. Is this possible and if so, how :confused: I know that you can transfer the contents of a table but I am only after the record that is currently displayed on the...

Hi there Haven't gotten around to trying this yet, but to just to clarify. When I press the button on the subform it needs to do the following: 1) run the append query, and then 2) refresh both the subform and the main form Earlier on I experimented by putting a refresh button on the main...

Hi there I have two forms in a database. One is the main form the other a sub-form. On the subform I am running an append query. My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data. Can you tell me if there is anyway or...

Hi there I have two forms in a database. One is the main form the other a sub-form. On the subform I am running an append query. My problem is this. Once the query has been run I have to come out of the record and back in again to see the appended data. Can you tell me if there is anyway or...

Hi there I would like to build a database whereby when I create a new record it generates a new reference. What I'd like is say the first record to be: SNN0001 and then when I create a new record the next record would be: SNN0002 How in the heck do I do this :confused: Thanks for any help...

Excellent stuff. Worked a treat! Thanks :)

Hi there Need some quick help with VB. I have no idea how to write out the VB for what I require but I believe it may be quick and simple for someone in the know. What I need is a MSGBox to appear if a specific field has not been filled in when a user tries to save a record. When the box...

Hi there I have a bit of brain teaser. Is it possible to transfer text/ data from MS Access columns in to an email message. Basically what I ideally would like to do is the following: 1) Have a column that has an email address in it and transfer that in to the "To:, CC: or BCC:" of an email...

Hi there Thanks for the reply. That is "nearly" there, but it is not what I am after. If you look at my second post that is what I after. Not sure how to explain it better :( Jools