Search results

Simply sourcing your textbox to any object works only of respective object is open in the back ground. If you don't want to have the object opened in the back ground use below expression in control source of the textbox: =DLooku("[fieldname]","QueryName") If you want to display a specific...

I did it but still if one of the forms doesn't exist in specified location, it gives me the message and stops all other macro actions. DoCmd.SetWarnings False DoCmd.RunMacro "Delete_DataInImportedTables_Before_this_Import", , "" DoCmd.TransferSpreadsheet acImport, 8, "Form A"...

Dear all, I have designed a macro in Access 2007 that imports data from 4 excel files. Name of excel files are Form A, B, C and D. I recently installed Access 2010. Now when I click the import button, the macro pops up a message saying that "Form A" doesn't exist in the specified location -...

Dear all, I have designed a macro in Access 2007 that imports excel data from a files. Name of excel file are Form A, Form B, and Form C. I recently installed Access 2010. Now when I click the import button, the macro pops up a message saying that "Form A" doesn't exist in the location - this...

I hope your date field tracks full date (dd/mm/yy hh:mm:ss). Using max on such a field value will give you the last submitted report.

What do you mean by report_number? If this field is already in your table so drag and drop it the next field in your query. If it's not in your table, and you want to count the reports for that user, then do a count of records. In query design, create an elias (field) i.e Number Of...

You can create all types of graphs. Try the Graph icon from the menu. The graph has it's own provoked query where you can play how you would like the results to appear on the graph. I would suggest that you create a query first for what you would like to appear on the graph and then create a...

Thanks, guys. Finally did it. It's always good to go for a break when things get crazy and restart after being refreshed.

Hello experts, Table1 has one field "Objectives". Table2 has one field too "ObjectivesBroken". Value for "Objectives" field is 'primary education, health and sanitation, vocational training'. I am trying to run below code to break the value of "objectives" field after each coma and append the...

How can I see all my posts only? One of you all respected experts had helped me with breaking text in a field into words. I need to see my posts to find that. Much appreciate your help.

Would this help? Build a select query on the mentioned table. Drop down all fields. In coloumn 11th, type this: UniqueKey: [field1]&"-"&[field2]&"-X"&Dcount("("*")","Table Name Here")+1 If value for field 1 is A, field 2 is B and the total number of entries in the table is 5, the above...

Do this: Drop a text box at the bottom of the last field. Then right click on the new text box, click on properties, click on data tab, and type below formula next to record source. =sum([ingredient 1]+[ingredient 2]+[ingredient 3]) This will give you total of all three fields for each entry...

Let me share my lessons learned using database on network. When we split database, the last thing access asks is the file name for the back-end database. This is very critical step. If you provide the whole path here, then your front-end will never ask you again for linking tables again and...

Did you enable all macros on Trust Centre from Access options. OR checking the coding on the button again if it exists. I have found several times that during compact and repair some codes are washed out from important buttons.

Here is a simple solution. If all fields (country, state, city) are in one table, then each country should have an ID, then each state should have and ID and city too. In this case, country ID will appear as many times as per the states of that country. And then country and state IDs will appear...

Well. I think, the coding you have done is dependant on Outlook. This coding doesn't have control over outlook to change sender's account. Maybe you would need to download "Total Access Emailer" or use CDO coding to send email through gmail account. You can search on Google for CDO Gmail email...

The easiest way is to insert row. Put your cursor in one of the rows of criteria, and then click 'Insert Rows' from 'Query Setup' group under 'Design' menu. You can insert as many rows as you need. Hamdard

Google mail is hosting email service for our organization. We use domain of our organization i.e abcd@ndi.org to open our emails on Google server. Probably change in password in our domain doesn't synchronize with Google SMTP server...does it make sense...???

Thanks, Sam. Can you illustrate what you mean by relay server? What would I need to change in the coding to connect to relay server? Hamdard

I just changed my Google account password. After 10 minutes, I signed in to Google mail with my new password on internet explorer. Here is the funny part, when I tried the new password from database, the database gave me the same transport error message with the new password - but the old...