Search results for query: *

Hello. i have uploaded a photo of my cross-tab. let me tell you the fields. the AD AU CO field is the category field. the 36,1,8,9,31 field is an auto number field because i have duplicate records that need to be there and Crystal combines all those into 1. and the number field is the amount...

I have a table with a field called CheckBox. it has a checkbox in it. i want to say if it is checked, then import 3 other fields into a different table. so far i have Private Sub CheckBox_Click() On Error GoTo Err_SomeName DoCmd.RunSQL "INSERT INTO TestCheckboxtable SELECT...

i have a button on a form called button1. what i want to happen is say when button2 is clicked, enable button1. as soon as button1 is click, disable it until button2 is clicked again. the reason for doing this is so that someone doesnt press button1 more than once between button2 clicks. Hope...

So i think this would be solved using a query. i have a button on a form called button1. what i want to happen is say when button2 is clicked, enable button1. as soon as button1 is click, disable it until button2 is clicked again. the reason for doing this is so that someone doesnt press button1...

Hi, i am running an Access 2003 executable and i have made 3 reports in Crystal and i want to have a button that opens the Crystal Report application and run the report. i dont want the crystal report to run IN access, i want a button that opens a report in Crystal. i have this Common Dialog...

I made a report that has category codes shown. they are like AU or PO or CO. what i want to do is say If category code = AU, the the field should change to Auto. or if PO then Postage Is there a way to do this for a report? i tried it, but it said that i couldn't alter that field Im using MS...

Hello again. my last problem is with Access Runtime. i split the database and i packaged the front end. i have the backend on a shared network drive. in my package, i require the user to have runtime on their machine. my problem is, when the user installs the package and opens it, the Access...

ok. i have a table called Category Codes. the 2 fields are Vendor and Category Code. the Vendor field are businesses and the Category Code field has two letters in it. when i import a bill into AmexCurrent, i want the Vendor field from AmexCurrentto look at the CategoryCodes table and say If...

So i have three tables. RawImport- where i import raw data AmexCurrent- where certain columns of RawImport go for editing AmexHistorical- where AmexCurrent data goes for archiving once its complete What i want to do is when data comes into RawImport and i move the data into AmexCurrent, i want...

So, i found a lot of code that lets you select a file and drop the path into a text box, but i need to be able to import an excel spreadsheet. i found some code on the internet Option Compare Database Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA"...

Im sure someone has asked this question, but i have been searching this site and others, and i cant from a code for what i want. i have an import button and i want the person to press it and a window to pop up an open file screen asking which file they want to import. thanks Valgore

So i have two temp vars. one called tempRecordSet and the other is called tempRecordSet2. tempRecordSet2 doesn't work. i know why, but i dont know how to fix it. Set tempRecordSet2 = CurrentDb.OpenRecordset("select * from AmexCurrent where UCase(trim(AmexCurrent!Cardholder Name!)) = '" &...

Another simple question... I current have a button that imports from excel to an Access table. i need to change the code to make it so when the button is pressed, the User decides which file to import. i also need to be able to hard code which columns and rows i want to be imported. All the...

I know i posted this question before, but I am still stuck. I am using Access 2007 and what i want to do is move all the data from one table to an "archive" table within the same database. i will do this every month. Ive looked at the Access Help and ive gotten many append query's. my first...

i have a database that is for Amex charges. i import charges in a table and when all of the charges are categorized, i want to click a button and have it move to a archive table. ive looked at all the functions and i cant seem to find a way to make it work. any ideas? Valgore

hello, i have created a database that allows users to logon and input their Amex charges. i created a run-time application and i installed it on one of the users PC's. my problem is that when i open it, nothing shows up. so i have several questions on where to go from there. 1) i created an...

im trying to make a log in form, and i keep getting "Run-time error '3075': Syntax error (missing operator) in query expression 'UCase(trim(User Name))='". i have made a table called UNP. it has two fields: User Name and Password. Im using Access 2007. here is my code Private Sub...

I have a list of user names and passwords in Access 2007. what im trying to do is when a user logs in to Access, each user has his or her own custom menu. how do i make a custom menu for each person? also i want to be able to limit what each user can and cant do. for instance, i want lets say...

Hi, im writing a report and i want the report to only show date range for every 6 months or month or 12 months. can anyone help me? thanks JB