Search results for query: *

Reply Apologies jmcilhinney I did exactly as you specified & changed the name of the menu item. Thanks for responding.. Clive

I have just created a new application using Visual Studio 2022 & created a new CHM file which has been added. For some reason when I compile this app I am getting the above error... can someone please point me in the direction of the problem? I have added what I thought were the correct...

Thanks for the advice... is there a sample VB.Net / Access application anywhere I can use for reference that anyone is aware of? for instance I am unclear on how the above response works when adding a datagrid? Clive

I have just created my 2nd VB.Net application today where I have created the database in MS Access 2019 and created the project in VS. The project consists of 2 forms at present. A data entry form and a database editor which I have setup using a datagridview. The datagrid is working fine (so...

I have an SQL query which was provided by one of the forum members which works fine.. I need to enhance this by making 2 literals which are part of the SQL query as variables. ' sqlSelect1 = "SELECT L_CALL, L_QSONR FROM LOGBOOK WHERE L_CALL = @callsign AND L_DATE=...

Thanks I can see what you mean! should have thought a bit longer... may I ask another query based on this... this is the 1st query I run, there is a 2nd query which is exactly the same other than I am not checking the time i.e. a match on the same day but time is out of the 5 minute ranges...

Thanks for the rely comprehensive response! I have included my version of the code incorporating the SQL from your response. I have this working with slightly different syntax... sql = "SELECT L_CALL, L_QSONR FROM LOGBOOK WHERE L_CALL = @callsign AND L_DATE=...

Thanks for responding.. at present I am not expecting an exact match because the data in the file is from some else so the time will be based on the time on their PC / or entered... (could be + or - a few minutes which is a pain).. and the time in the database is when I logged the data. I...

I have a file I am reading which contains the time in HH:mm format. I need to use this to query against an MS Access column which is defined as Date/Time but only contains the Time. I would appreciate some help on how do I convert the incoming value from a string to a Time I can use in an SQL...