Search results

Hi! I don’t know if I understood properly what you want to do but if was me I would do like this: If a book were out I would put it in the reserved list with available dates. After someone reserves any book on certain date, that date would not be available to reserve anymore. Hope this help...

I've created: 1 - form called frmtest 2 - 2 text box call txttest & txtYearBorn 3 - button 4 - table called tbltest with field names ID & Name & Year born Then I written on the form frmtest the following code: Option Compare Database Option Explicit Function test() txttest =...

Try dcount instead count. I've just checked and it works perfect in mine TxtboxName=” DCOUNT (rowcount) FROM tbltable” jonyBravo

Try this: txtboxName = sqlstring of this TxtboxName=” COUNT (rowcount) FROM tbltable” Please let me know. Thanks

Hi! As I'm new on Vb I wondered if I build an application on visual Basic and create SQL Statements to an access database, do I need to have an SQL Server? Thanks JonyBravo

Thanks, Im more confident now. JonyBravo

Hi! I build access databases and my boss now gave me a project where I have to use Visual Basic 6. I wondered if as I’m use to programme access VB I will be able to programme with VB6 or I should be better get some training first. Thanks JonyBravo

Hi! Can you explain better what do you want? JonyBravo

Hi! This is exactly what I want, but I would like you to explain me something. What is the difference of using: Me.txtFullOfText or just txtFullOfText when the final result is the same. Thanks to help JonyBravo

Hy guys! I would like to know if is any way to inverse the following code: This: if isnull (txt1) then 'recognise if the box is empty to something like this: if isNotNull (txt1) then 'recognise if the box is not empty Thanks

Thanks to help me! I do understand what you saying but my problem is, I need to use two different tables and I want to delete on tableA if tableB says to. I want something like the following code but to delete the result instead return. SELECT tblPlanner.Date, tblHolliday.RACF FROM...

Hy again! Can someone please tell me why the following code doesn't work? DELETE tblHolliday.RACF AS EXP1, tblHolliday.Date FROM tblHolliday INNER JOIN tblPlanner ON (tblHolliday.RACF = tblPlanner.RACF) AND (tblHolliday.Date = tblPlanner.Date) WHERE (((tblHolliday.Date) Like...

Thanks Pauldohert JonyBravo

Thanks to everyone but I've find the soluction as you can see on the following code: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblPlanner ( RACF, [Date], [Day Capacity], [Role Title], TimeWork ) SELECT tblStaff.RACF, [txtday1] AS Expr1, tblStaff.[Daily Capability], tblStaff.[Role...

I've the following SQL query in my database: DoCmd.RunSQL "INSERT INTO tblPlanner ( RACF, [Date], [Day Capacity], [Role Title], TimeWork ) SELECT tblStaff.RACF, [txtday1] AS Expr1, tblStaff.[Daily Capability], tblStaff.[Role Title], tblStaff.[Contract mins] FROM tblStaff WHERE...

Hi there! I'm using the following query code in my database: INSERT INTO tblPlanner ( RACF, [Date], [Day Capacity] ) SELECT tblStaff.RACF, [forms]![tblLeader].[txtday1] AS Expr1, tblStaff.[Daily Capability] FROM tblStaff WHERE (((tblStaff.TeamName) Like [forms]![tblLeader].[txtTeamName])) WITH...

Hy! I've putted on calendar on an database but by example when I press first of June how can I make it recognise which week day is it? Thanks

Hy! I need to build a holiday staff database for my employee in Access 97. Is there any idea to how can i do it? Thanks

Thank you very much! :) Jony Bravo

Hy There! I need to improve my skills in Access VB. Can someone there tell me the best book I can get to help me? Thanks