Search results

I am learning to push tables from Access 2010 up to SQL Server (2005). When I "upsize" a table, Access shows the table linked. This means I can no longer run ALTER TABLE queries. I have read some threads which say "Upsizing is a one-time deal, you should not need to alter...." In my case...

I have a modal dialog, with 3 buttons- one for each type of report. when the user clicks on the type of report he wants, that report opens behind my modal dialog. BUT- when the user clicks the red X to close the dialog- he is navigated back to the page which opened the dialog. is there a way...

Access 2007 Multiple item forms are fantastic. They have been the number 1 tool for meeting my clients needs, so far. Despite all my praise, there is a trouble I run into from time to time. I can't seem to use VBA to change just 1 item in the form. For instance, the form currently shows...

Thanks for the prompt reply, Bob, it worked well.

I want to insert some rows into a table called 'payments' Every payment has an ID (auto-number) I am more comfortable doing this procedure using the SQL view of Access 2007. what is the syntax to insert the next logical value into an auto-number field? In MySQL I would write 'default' for that...

@ missinglinq : You completely nailed it, my Access trust center settings did not include my working directory. Thank you both

Hi, I'm new here. I have built a multiform. It has a field called "account" which I want a toggle button to lock. To achieve this I inserted a button in the form header. I have chosen Events tab -->ON Click -->Event Procedure In this VB dialog I wrote: Private Sub Command14_Click()...