Search results

Sorry nIGHTmAYOR I am a self taught vb noob I'm afraid, however 'great success' I have it working now was a problem in the strSQL2 statement defining the ArgID etc. Its extremly ugly but its working now for a training session I have tomorrow morning. Private Sub InputClose_Click()...

Just a quick update the problem is definitly occuring in this section: strSQL2 = "UPDATE [Schedule Details] SET [Schedule Details].StudentID = '" & ArgID & "'," & _ "[Schedule Details].RoomID = '" & ArgRoom & "'," & _ "[Schedule Details].StartDate = '" & ArgStart & "'," & _ "[Schedule...

Hi guys, table involved is called [Schedule Details] >> i know its not good to do this now I keep getting an error 3464 with the update section. Heres the code: Private Sub InputClose_Click() DoCmd.SetWarnings False Dim strSQL1 As String Dim strSQL2 As String Dim ArgID As...

I am sorry pbaldy I opened the database today and the search was worknig as normal - I must have missed an option in the search screen as it only working for ID numbers. My bad :(:(

Hi Guys, Recently I changed my form so that the dlookup expressions I had to look up values in another table were put into vba. This speeded everything up however now when I search for something it isnt searching for the values. For example before I had a code box and a name box and the...

Hi peeps I have several dlookup expressions on my forms looking up values in other tables which work fine. My only problem is if they cannot find a value becuase it isnt there for the odd record i get an unsightly #error message in the box. Is there anyway of stopping access displaying...

Thanks for your reply I understand how the db table setup would look like I am struggling to see how this could be setup on a form - I'm not sure if its possible tbh. For example if 2 students were having an arguement - at present I would input 2 records with 2 ids via the form Ideally I would...

Hi Guys & Gals Someone has just pointed out a fatal flaw with one of my table designs involving incident reporting. Current Structure: tblStudents StudentID StudentName etc tblIncidents StudentID IncidentID IncidentType etc At present the StudentID is linked on tables which means that...

Hi Guys, Bit of a problem here I am trying to add a method of viewing/adding/editing info on a form. tables tblstudent studentid tblrooms roomid roomNumber Block tblScheduleDetails ScheduleID Studentid Roomid Dates Now my main form is based on a query of tblstudents &...

:P Yeah, I was wondering why I couldn't do this. What I have ended up deciding to do was to build a seperate front end with different forms for the wardens to use. Thanks for your help though:)

yes, however I'm a bit better at excel so in that case I would export the info into a 2nd excel sheet to format the data either manually or you can create a macro and then move it into their spreadsheet:)

sorry yeah you'll need to link them tblcustomers customerID Customer Name Telephone No Address tbljobs JobID Job booked Y/N Date of booking (date) Complete Y/N Date of completion (date) Completed by (engineer name) Additional notes with a one to many relationship on customerid - jobid

Securing tables for different user groups Hi all, I have a database with 3 levels of users - wardens,admin,managers I would like the wardens to be able to view the everything however only be allowed rights to modify records in certain tables. Is this possible in access - had a quick search...

I would use a combo box for the engineers name and then have a subform showing work done. tblcustomers Customer Name Telephone No Address tbljobs Job booked Y/N Date of booking (date) Complete Y/N Date of completion (date) Completed by (engineer name) Additional notes should be alrite:)

sweet:P namliam's advice of not using spaces in names is very important, I spent a whole morning going through my db replacing spaces and it wasn't fun:(

Hi Dark, I'm not too sure however to me it sounds like you are using an access table and an excel sheet at the same time and you want them updating. So if something is added to the excel sheet it gets aded to access and vica versa?

Hiya, If you want to populate the form via the two tables You should base the form on a query of the two tables go to form properties and under 'record source' create a query selecting all from both tables Then your'll be able to link the fields in If this isnt what your after let me know

Fantastic ortaias should be able to get an idea of what I need Thanks!! James

Hi Peeps Thanks for the help I've had so far with my project however I am stuck with sorting out the basic design for a particular part of the database. Basically I have to keep track of international students staying in Rented accommodation. There will be approximatly 100 students at any...

In Excel I'd use something like this =CONCATENATE(LEFT(A1,3),LEFT(A2,3),RAND()) The Rand Function is used differently in VB though (rnd)