Search results for query: *

Hello, Im stuck and need some help formatting a field in my append-query. Example: 50.00 Need it to be at least 7 digits with leading zeros and no decimals So it would be "0005000" Also the field in my table were I need to store this value is TEXT. Does anyone know if this is possible? Mike

hello, Im trying to find the code for creating a command button. I want the user to be able to click on the button and a new query design dialog pops up. Similar to what happens when you click new query in the database window. I want the user to be able select the tables needed for the new...

Hello All, Im trying to write some code in VBA to check the current version on the users local pc against the server-side version. If the server-side version is newer then the local version, close the DB, update local version, and restart the lcoal DB. Does anyone know how this can be done...

Hello All, A little background on what I am trying to do. I have a shell database that has 1 form and allows users to add/delete/import id numbers into a listbox. I then need to take these id numbers and run about 12 update queries. Since multiple users are using this at the same time...

hello all, I am stumped. I have the following code. I am trying to import only worksheets named "AGT" or "CORP" in 1 excel workbook. I am getting a data type mismatch error 13 when trying to get the worksheet name. Please see the code below. Private Sub cmdSplit_Click() 'Make sure user...

Hello, I am having some trouble. I am trying to export a table into a .CSV format(docmd.transfertext method). But... Each .CSV file needs to be by State. I have a table(tblImportToAGT) with the following fields: Example of table data ST SSN LASTNAME AK 111111111 BRUCKMAN AK...

Hello, I have a main form with about 14 tab's and on each tab there is a subform. Everytime I try to enter data on a subform it will let me, but when I close the main form and re-open the main form and subform my fields(data) are blank? Each subform has its own query and there is data in the...

Hello, Hopefully someone has a simple answer to this. I am using a form to add a new record. I only want the user to be able to enter 1 record and no more per form page. Im having problems, I disabled the navigation buttons and if you tab all the way through all fields it goes to the next...

Hello, Our company is still using Access 97. Is there any examples out there that can show me how to create a custom dialog box using a blank form and VBA code? We can not use Microsoft's ActiveX control Dialog Box. Thanks for any help you can give!

Hello, I am trying to convert a date format. Examples 12/3/94 to 120394 1/8/05 to 010805 1/22/06 to 012206 It has to remove the slashes and be in mmddyy format and how can this be done in a Query? Can anyone help me out with this. Thank you, Michael

I have a help file system that i want to be executed on a button but I can't figure out the code to execute it. Can anyone help?

Hi, I am wondering if I can use a variable in an Access Data Page. I know you can use a text box in forms and reports to get the variable value but how can I do this for a Data Page. I tried using a text box and that doesn't work. Thanks, Mike

does anyone have an example of a SQL create table with primary key? and a insert into example? Thanks, Mike

I need to have a module search through a table of each field on each record and get the field names if value is -1(which is checked) and return the field name(s) im having trouble opening the recordset and searching this is what i have so far Public Function GetExceptions() Set db =...

I am trying to create a DSNLess connection from my database to another so I dont have to set up DSN connection on every PC that uses my database. So far i have the DSN connection working but like i said i would like a DSNLess connection Global Const ConnectStringDSN =...

i am also having problems getting division by zero. It might have something to do with null values in my table. How can I check to see if null in my table but when i check i need it to be in a query. Like some kind of Iff command in my SQL, if null set to 1 because i am dividing by the value...

I came upon an error when running a couple queries. I get cant use "qryname" as a row source? I believe it has something to do with null values in my tables. Is there a way to check to see if null value. I also get the set 1 field to null data type converison error. This might help...

i would like to code my startup form to search a table and compare it to the network login. I have the code to return the login name on the w2k box. And I have created a table with just 1 field called username. table = tblUserAccess field = username can anyone help me out?

I need to check yes/no checkbox fields to see if it is checked in table per record. Then, if the checkbox is checked, I need to display the field name(s) on the report. Anyone have any ideas? Michael

I need to pull the records using our companies fiscal year calander. What i did was made a table by months with the startdate and enddate. example below tblFiscalPer AutoID PerID StartDate EndDate 1 1 12/29/2002 2/ 1/2003 2 2 2/ 2/2003 3/ 1/2003 3 3 3/ 2/2003 3/29/2003 4 4 3/30/2003 5/...