Search results

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...

when importing a using vba and a import spec. should import spec be on front or back end?

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?

But doesn't the upswing create pass through tables(the one with the globe icon) only?

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

I have a fully populated combbox, however i want the user to have the ability to change the text of the currently selected item in the combbox. Any idea how to do this? so something like combox1.listindex(current.index).text = "My new text" Kind regards

Hi, in access 2007, i create forms using the wizard based on a table, when i move the size of the text box and other objects, they all allign together, however when i add additional fields after using the initial wizard, they do not allign and i have to manually position them. Is there any...

I am just using SSMA for migrating my access database to sql server. using the wizard it migrated the tables to as linked tables. I have LOTS of sql queries which i want to convert to pass through, is there a quick way to do this? Kind regards