Search results for query: *

hi, does anyone know how to search en entire db for 16 digit number strings? need an audit system to ensure that credit cards aren't being recorded in a db. thanks

hi, trying to use the Onchange in a vba statement but haven't been able to figure it out. I also search but couldn't find the solution. essentially, here's what i'd like to achieve: if me.text0.onchange = true then do this.. else do that end if thanks Martin

hi all, need some help with something I haven't used in the past. I need to use vba to pass a query which contains two conditions. Here's what I have so for but it doesn't work. I can't see where i've gone wrong so hoping to get so help. I need to pull all records where the field "Claim_New"...

hi, I'm looking for some help and direction to create a user form that allows me a search criteria and then retreives the information from a sheet named Data. I've tried the built in Form function but didn't like because of the formatting it provides and the fact that I can't have more then 32...

hi, I have an access aplication that when opened it first opens an agreement window. When the "I agree" button is selected, it runs several codes, to eventually open the main working form. one of the codes is opening Outlook and when this happens, the focus is set on outlook. How do I get the...

Hi, is it possible to query an oracle db via passthrough where the date field is between two fields that the sql code would fetch from a form? for instance, I'm looking for all the fields where the tran_date is between [forms]![password]![text156] and [Forms]![password]![text158] and also where...

Hi, I'm working on a project where we are migrating an ms access backend db to Oracle. one of the things I need to do efficiently is delete an oracle table. when using the delete function, it takes forever. I understand that there is a way to "truncate" the table which is much faster, but I...

Hi, I'm working on a project were I need to link an Access 2007 front end to Oracle tables. When trying to link to the production tables through Oracle 8.5, I can link some tables but not all. For those that I can't I get a message stating that the database engine could not find the object...

Hi, I'm working on a project where a database was created in MS access and is split BE and FE. We are now moving the BE to Oracle and have determined that the current backend is using reserved words in certain table field names. Is there a way via code to change the field names automatically...

hi, looking for some guidance. I have a form in which there are several list boxes. each list box has it's own query. List0 has several columns (store, dept, class name, sku, description, units, total, date). What I would like to have is a text box on the form where I can enter the sku and...

Hi, is there a way of fetching the CPU usage that is found in the Windows task manager, Processes tab? I'd like to add this value for my ms access file into a form in order to help me monitor performance. thanks Martin

Hi, I have a query that I populates an excel template which is then attached to an email. the code that i peiced together from doing some research works very well. The only thing is that I would like the excel template to save itself autoomatically. the way it currently works is that the user...

Hello, i know this is probably an easy one, I just can't see where i'm going wrong. I recently converted an Access 2003 application to Access 2007. For the most part, the conversion went well, except for a few codes that I was able to fix. The below worked perfectly with 2003 and now doesn't...

Hello all, I have a front end that I created using Access 2003. I few years back I found a post with the coding to Changeproperty at login (parts of it below), so if the person logging in is setup as an "Admin", then they have access to everything, however, if the person is setup as a User, then...

Hello everyone, I was hoping that someone could help…I’ve been at this for way to long! I just can’t see where I’m going wrong here ? I have a query named 'storenvr7' which has several fields. I’m Looking to show record only from a specific store and reason type. I can get it to work for...

hi, does anyone know if there is a way to have all records in a list box automatically selected when the form is open? thanks

thread702-1516961 I found the above thread where someone posted the below code that works great for creating a sort button for a list box on a form. The only problem that I can't seem to solve is that I lose the formatting in the fields that I sort. For example, I have a total field that has...

Hello all, I'm looking for some guidance. I have a form that is tied to table A that contains the following fields: Store, sku and comment. In my form, I have a list box that is tied to Table b that contains a number of fields including Store, Sku, description, units, cost, ect.. I would like...

Hi, I need to open open an exe file via a button on a form. I have the following code but I get a type mismatch error message when I run it. I'm obviously missing something here. not sure if I need to reference the full path of where the file is located (Y:\CMS\CMSUPDATE1.exe any help is...

Hi all, need some help with something that seems to me very basic, but for some reason I just can't get it working. Im using access 2003 and I have part of this code in my password page. essentially, if the person logging in is not an admin, I want the program to restart with minimal menu and...