Search results

Hi Many thanks for your help; I await the bug fix!!! I have used the workaround by setting "double" in the options. Regards Ron

Hello Trevor G; I was trying to add a new table to an existing database. However, I have created a simple new database from within Office 365. I have created a field and set this to number; the field size is defaulted to "integer" from Options, but the pull-down list is blank and will not...

Hi everyone! Yes its many weeks since I last posted a thread. But now windows 10 and office 365 later, I have a problem - probably I'm not seeing the right way to do this. So, I am just starting a new database design - the first since I switched to Office 365. I am trying to format a number...

Hello MackMan Try drawing your logical flow in the form of a logic diagram - a flow diagram. In the early days of programming - machine code etc.., this was the only way to perceive the flow of control. For example, "if" is represented by a diamond containing a question- enter through the...

Hello CJ_London Now the thread is complete; many thanks till the next problem!!!

hello CJ_London many thanks again for your patience and help; I believe I now have the problem solved - but just a few points about the "insert" statement you could help me with: 1 could you please explain the syntax of the text portion of the statement: ,' " & textvariable & " ', 2 I...

hello CJ_London many thanks for your response - I have moved forward. I used this code CurrentDb.Execute " INSERT INTO test_table_01 " _ & "(item_01,item_02,dbamnt,cramnt) VALUES " _ & "('ross', 'poldark', '899.45','777.23');" to append a new record into my table -...

Hi everybody First I hope this is the right spot for this thread. I would like to load a record into a user form from my database table, read the data from the form into a VBA procedure, manipulate this data, and then create a new record from the manipulated data. Manipulated in this context...

Many thanks for your reply. Not sure how to add a button to do this, but I'll have a try. I do have a work-around - print the report and then scan to file in PDF format. Ron

Hi everybody! it has been sometime since I last posted, but I hope my new problem will make up for that. :) I would like to export to file my reports in PDF format; the tool to do this is on the ribbon, but when I click it nothing happens - I've checked the help file and that indicates what...

thanks for your thoughts, but with respect, I did not intend this thread to be about windows 8. I just would like to find the visual basic language reference regards Ron

Hi yes, I have been away from this forum for some time - time flies is really apt here. I have just purchased a new fast-lots-of-ram pc - the last one my wife says!!!, so I decided to update to windows 8 and office/access 2013. I was looking for the access visual basic language reference which...

Hi i am about to move to a new 64 bit windows 8 pc. currently I have access 2007. is there an upgrade from access 2007 to 2013? many tnanks ron

thanks - I have little experience with queries, but I'll have a go ron

Hi! I have a database table containing – among other data fields – 'name', 'task_date',. 'end_task_time' and 'start_task_time' I would like to create a report showing 'name', 'task_date' and 'task_hours'. Decimal 'task_hours' is calculated from ('end_task_time' minus 'start_task_time') * 2.4...

Hi Thanks for all your help. the problem has gone away!!! would closing down the database have reset the table/form in some way? many thanks Ron

hi David open database, then open form - at that point it asks for parameter value Ron

Thanks for that quick reply - I deleted the control source on the form design - but it still asks for a parmeter value. this is a new table and form, so it has no links or queries thnks Ron :confused::confused:

Hi! I have deleted a field from a table; however, when I open a form associated with that table, I get a window asking for a parmeter value for the deleted field - even though I have deleted the field from the design of the form. How do I get round this? many thanks Ron:confused...

hi! I would like to add an unbound field on a form to calculate the arc cosine of a value in a bound field. I would prefer not to use a VBA formulae. So far I see that I can get sines, cosines, arc tangents, and derive "pi" from the arctangent. How can I use these to produce an angle value...