Search results

Thank you once again David - seems to have worked a treat

Hi, I have a query with 3 fields (RecordDate/Site/ComplaintType) I have added Criteria in the RecordDate field to select a date range & I have added Criteria in the Site field to select the site. What I am looking for this query to return is a subtotal of each complaint type recorded at the...

Hien Muoi- Thanks for pointing out my error in spacing! This seems to be my constant failing when it comes to code- It has taken me a further 20mins to realise that I need another " " to code correctly! My final code = Shell ("net send" & " " & "mycomputername" & " " & "mymsg") Works...

What I'm attempting at the moment is on the on click event: Shell ("net send" & "mycomputername" & "" & "mymessage") This brings up the command prompt tab for a split second but then it disappears again before i can check to see if there are any errors & the msgbox does not appear on screen...

The user sending the message will have access open when the message is sent at all times- I am hoping to tie this in to an 'on click' event from a command button. The user recieving the message may not have access open- this was my thinking behind using the command prompt messenger- that the...

Gemma-The users are all on a small network but do not want to use MS Outlook, what I'm trying to do is spread information around using the net send command on the command prompt messenger-so for example user 1 enters a record and clicks on a command button & a pop up box will appear on user 2's...

I have a command button within a form, When the user clicks on the this command button I wish for my db to- Run a qry to colate the necessary info Open Windows command prompt Transfer the info provided by the qry into command prompt as text (with the idea of using the messenger service) send...

My 1st db split-Help needed please I have just finished my first ever database and will be installing it onto the companies computer network soon (hopefully), There are a number of users at various work stations who will need simultaneous access to this db- I have done some background reading...

I have just finished my first ever database and will be installing it onto the companies computer network soon (hopefully), There are a number of users at various work stations who will need simultaneous access to this db- I have done some background reading into this already but most sites...

Thanks again this also now works superbly! I very much appreciate your time to help a newbie.

Hi pbaldy, On the first issue many thanks, that's worked exactly how i'd hoped. On the second issue-you are right in your assumption that I'm using a combo box. So from the records table design- for the customer field I have used a lookup wizard, selected my customers table & used customer...

Hi all, I have a form for entering record information into a table- within this form there are 2 fields (that correspond to 2 fields within the underlying table) that I would like to auto populate with information to save the user having to manually type this in every time they enter a new...

Thank you- I put that line in at the start of the code and it appears to prevent the Write Conflict message box appearing!

Hi all, I have 3 forms Entry/Analysis/Follow Up, these let users add info into records held in 1 table- Active Complaint. The entry form has a command button that opens the analysis form & the analysis form has a command button to open the follow up form- however if someone goes through...

That works a treat thank you very much!

I have a form (single view as opposed to continous) that has the on current event built into the form detail properties Private Sub Form_Current() If Me.Status = 1 Then Me.Detail.BackColor = vbGreen Me.Form.AllowAdditions = False Me.Form.AllowEdits = False Else If Me.Text20 > Me.RequestedBy...

Thanks for all your time & help it's been much appreciated- I think I need to get my head into the books a bit more before I go forward tackling my various db issues!

As an On Click Event-would it be better another way perhaps?

Thanks that seems to work-when I attempt to 'click' the status check box a Message Box appears with the appropriate message. However when I click ok on the message box the status check box is still marked complete. Is there some additional code I could add to prevent this-for example you...

Thank you for that- I thought that an on click event procedure with an If function would be a more basic way of achieving the desired effect-however with my very very limited knowledge on VB & code I'm struggling to achieve this- my if so far looks like this Private Sub Status_Check() If...