Search results

How do I clear the data on a form without it affecting the actual data in the underlying table(s)? I would appreciate it if someone could give me a solution without the need for vba, because even though I can do vba unfortunately my colleagues can't. Thanks.

I hope this is the right forum. I have a database that has a data backend (shared on the office server) and a frontend that sits on the users pc/laptop, some of these users want to be able to work on the database remotely, ie at their home. What i would like to know is is it possible for these...

Is there a way to auto center all forms in a database, without going to each form and setting 'Auto center' property to YES? For example, is there any vba code I could use? Cheers!

How can i return data, which has a date formatted as 'mmm', which fall after the current month? For example; me 12/apr/09 them 09/apr/09 you 24/mar/09 it 07/may/09 from the data above i only want to bring back me, them and it. Ta.

I have a database with linked table to Excel spreadsheet which produces a #Num! function in some fields. Background: The excel sheet is produced from access on the click of a button. The user can then change the data in the excel sheet, and then obiously save and close it. But if the data...

I have a textbox that runs a bit of (sql) code whenever the user inserts a character in it, and then resets the focus back to it using sellength as part of the criteria. txtSearch.SetFocus txtSearch.SelStart = txtSearch.SelLength + 1 The problem is that when the cursor is placed back in the...

Is it possible to create some sort of conditional query? For example, i have a table with the following data in it: F1 J1522 DBR Location Product MC 1103 G S1 chassis MC 1105 G The data is in a text field. What i want to be able to do is bring back only the records (lines) after the 'Product'...

Can anyone advise me on the following please. I was just wondering if it was possible to loop through a tables data (cell by cell), much like you can do with an Excel worksheet in vba. For example; Dim objXL As Object Set objXL = CreateObject("Excel.Application") Do Until...

Is it possible (in access 2003) to do some sort of search to find out which macro(s) run a certain function or code? For example, I have a function called 'MakeCSV' and i'm trying to found out which macro(s) actually run/reference this function. Thanks

can anybody find a not too deliberate mistake in the following code: sAppend = "INSERT INTO 'TableName' ( TradeCode, Trade, CompanyName, Town, County, PostCode, Fax, Contact, Mobile, eMail )" & _ "SELECT Subcons.TradeCode, Subcons.Trade, Subcons.CompanyName, Subcons.Town...

starter for 10: whats wrong with the code below. i get the following error. Syntac error in query. Incomplete query clause. DoCmd.RunSQL "INSERT INTO 'TableName' ( TradeCode, Trade, CompanyName, Town, County, PostCode, Fax, Contact, Mobile, eMail )" & _ "SELECT...

a have a form with a combobox. how do i populate it with the names of the table in another database

can any tell me where i'm going wrong with the following code. i'm trying to copy selected dat in a table form a main database to a new table in a new database. PROBLEM: it stops at the "table already exists" error even though the table doesn't exist Function CreateTable() Dim TableName As...

i have a form thats loosely based on a table, and i have some textboxes which i put my own info in. is it possible to save this info to a different table ? if so how? please help TA!!!!!!!!!

is it possible to put a version number on my database like you can with a date stamp ?

can anyone find a problem in the following code ? why won't it tell me that a table exists when i create a table with the same name. code i use: Function CreateTable() Dim TableName As String Dim strSQL As String Dim db As Database Dim td As TableDef Dim bExists As Boolean 'On Error Resume...

is it possible to use one form to display all data from different tables. example: use a combo box to list (select) the tables, then have form1 display all data from the selected table. comprende. Matt

how can i temporarily adjust the resolution of a users screen to suit my database then revert back to their usual screen ? cheers! Matt

why do i get an error in the following code: Dim db As Database error message: compile error: user-defined type not defined matt

how can i use vba to check if a table exists in a database that resides on the network. example: db1 has a form which has a button that creates a table in db2. db2 is on the network server, does table created thru db1 already exist in db2 ? Matt