Hi,
i have a table bound to a form (like a subform) - its more of a tempory table but i use it to show multiple rows on a form. i call this tbl_temp.
there is a field with a combox in it . (eg i bound the fields propertys to a combo box) - however is there a way to have new values based...
Hi -
I have a distributed MS access application (front end and back end infrastructure) which occasionally throws a error. and its because it runs a Delete query and table is locked.
Cant work out why this is happening - any ideas.?
Kind regards
Manpreet Ruprai
Hi,
I have a excel object I have opened, and want to copy a query into a named range on the workbook.
any idea how? heres the start have made
Sub openExcel()
'WillR - opens the specified Spreadsheet
Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Set xlApp =...
Hi All
have a access 2007 file. with a table with a yes/no field. When I link the table to another db using lnked table manager, the yes/no display is not a checkbox(as set) but is turns into textbox. any idea why this is happening?
knd regards
Hi,
I have a mdb file i need to compile as a mde file.
However i also want to stop access to tables, and no menu bars(so it looks like a professional application).
any body have some code/process to do this cleanly
many thanks
I have a adp file - with a subform (data sheet view)
The subform contents is based on a SQL Query.
I want to get some group by information to display in main form.
Is there a effecient way to do this??
Can i do the query on the subform(without intergating the sql server)? or do i have to...
I have a subform.
On the mainform i want a label to display number of records displayed in the subform.
Whats the most effecient way (given im using a adp)
should i just recreate another query with count?
I have creating a access adp.
It Has a subform linked to a sql string recordsource.
Whats the most flexible way of exporting this to excel?
Would it be to use the sql string?
any one help
Kind regards
I have making a adp linked to a sql server 2008 database.
As many users will have the adp frontend a key requirement is to reduce server load and minimise connections to the DB itself.
I have questions on the following elements, how do they handle connections? do they open and close as...
Hi,
Just needed your advice.
We have 2 sql server 2008 databases.
One for PRODUCTION the other for MI and reporting.
On a daily basis(or more), i need to move data from the production be copied to the MI database automatically.
Whats the best/quickest/risk free way of doing this...
Hi I want to copy all the database(SQL server) to another SQL server database. However as I don't have access to SQL server management studio, is there anyway to perform this using access vba using t SQL?
Ok i have a combbox box with a reason
the user can enter a description (in a textbox) on the reason in the combobox.
I want the user to be shown which combboxbox items(reasons) they have added a description to.
I wanted the items(reasons) to have bold text but i heard this isnt possible...
Hi,
we have a access 2003 database, and want to convert it to adp - with a SQL 2008 back end.
Is there any issues with this?
any guides to do this?
does access 2003 have a wizard to assist with this?
Kind regards