Search results

hi ppl, i have been tearing my hair apart over an issue i have been trying to fix for the past 2hours I have a database in whcih i changed the fieldname. subsequently i changed the field for all the queries but i ran into problem with one of the query that contains this fieldname. suppose i...

Dear all, i have a question on subquery on calculated field. i have extracted the first 4 letters from a field to form a lookup id [left(A,4)] = Y (end results of the left formula). in the same query in design value, i want to join Y to another table (let's called it TABLE2) that has the same...

hi people, I have a pro with a form that is supposed to show the month name when user query data by inputting month number (1= January, 6 = June etc). i set the control source of the text box (that is supposed to display the month name) as =Format([Forms]![Cover]![MonthNum],"mmm") where...

Hi guys, I have a vba to auto export access data to excel. the function 'SendTQ2XLWbSheet' is activated by an access macro. There are many workbooks to be exported to and each has 2 tabs "Sheet1" and "Sheet1". I save these files with "sheet1" view (so when i open these files, it will be on...

Hi everyone, i have a query. how do i subtract numerical values btw tables? pls look at the atatched file. i have 2 tables (Table1 and Table2) with several fields [ABC], [XXX], [YYY] .... in both tables. i need to subtract the values under these but i need to get what is displayed in Query1...

Hi ppl, i have combined a few queries using an union but when i tried to run it, there is an error message "System resources exceeded" When i researched online, it seems the union was badly designed and as a result, exceeded the character limit. ive read some proposed solutions such as "not...

hi people, apologies if i am digging up what had been mentioned and resolved. i surfted the net for my issue which is that my split database is stuck. i have a back end daatbase on shared folder and a front end on my local drive - it was used to process approx 50000 rrows of record. things...

hi people, i have problem with creating a field that reads as 1.01 2.01 3.01 4.01 ......... x.01 where x is running autonumber from ascending order i need it to be in a query and I've tried to put in autonumber in the query itself which works fine but it splits up the number. for e.g...

hi people, i am trying to export access data in form of excel tables and put on a ftp server. i have researched online and have found quite a number of resources online. however i couldnt get some of the vbas to work i am quite confused here as i have read conflicting messages - the ms source...

hi people, i have following code that i atatched to command36 button to import excel file (HKG.xls) at "input" tab from a folder C:\Country. this will be put in a new table called "importCtryTest7". a problem i have here is the import works but not fully. I had missing data and upon research, i...

dear all, i was using a code to automate export from access to excel (_ConsolidatedCCRraw). ive had no problem till recently when i activate it and it returns me a compile error message - variable not declared. I shut down my database and revive it and notice sometimes the code works after...

hi all, i have created a combo list named "Country" and also a combo button on the form to link to report - pls see attached file i have the relevants tables and report may i know how do i design in such as way the "Country" combo list will have a drop down list (content is SG, HK) that...

Hi people, one question. I know there is an option in access called "relationship" in which you can create the links of all the tables and queries etc May i know is it possible for access to auto display the overall relationship flow chart and all the linkages btw tables, queries etc instead...

good morning all, i have an issue with automating excel import to access. ive got a link on how to do it (sorry i cant show link as i have less than 10 post count) but still couldnt get it working what i am trying to do 1. Import 1 worksheet called "Input" from 2 excel files called "HKG.xls"...

hi people, i have a problem here which i hope you can enlighten me abt. my database has duplicates due to different currencies used. The currency value is not duplicated but the weight is. sorry if i am confusing you so its better that i give an example. consignment ID [12345] Weight...

hi people, i am a frequent user of ACCESS but mainly work with the objects to build queries etc, hence pretty weak in advanced stuffs that require SQL and VBA. I want to go deeper and acquire more knowledge in these areas and i know the best is to pick up both ..but can anyone advise me which...

Hi people. have a problem here. i was trying to export an access table to multiple excel files grouped by a field (country). Below is the code i have built into a command button in form so the export can be done by clicking on it there is an issue here - i need access to export the data...