I have created a custom toolbar called Reports. It has file/print to allow report printing from preview. I set the reports toolbar property to "Reports" but when the report is previewed the to...
I have a very big database and I need to worry about size, and think of ways to make it smaller. It is 1 gig!
Here are a few questions:
1) does the "text" datatype in access behave lik...
Experts,
I need to write some code that will perform the same function as below but instead of Snapshot - they have to be PDF
(Reason - I am going to send live hire reports automatically...
I have searched the EE exchange and didn't seem to find the answer...
In a report, I want to concatenate an autonumber field with a string. So, if Autonumber is "1", I want to display in...
I have two tables that have matching columns called "displayname." How can I update certain fields within the first table based on matching displaynames in the second table.
Table1
Table2
...
Working with an Access database in ADO.NET (using ASP.NET)
Dim strSQL As String
Dim strSearchFor As String
Dim arrWords As String()
Dim arrWord As String
...
I have a data entry form to create values for a list. I have prevented the user from entered 'apostrophe's', but when the user types
dont
without the apostrophe, MS ACCESS automatical...
This is not really a need but something that is puzzling me and so I thought to as you Experts for help in understanding...
I've built a function that needs to import records from a SQL dat...
How can I create a trigger in Access. I know how to write a trigger in SQL, I just want to know where I go in Access to do this. On the right I see Tables, Queries, etc, but no triggers. Tha...
Hello experts,
Newfield: Mid([MyField],InStr([MyField],",")+1) works fine
http://www.experts-exchange.com/Databases/MS_Access/Q_21350976.html
in trimming text preceeding comma such as 01...
Dear All,
are there anyone who know how to play animated GIF in access form????
Please Advise,
Thanks,
Ozhee
I am setting up a new db and the tables don't really have relationships. I think if I take my parent table and add the auto id's of the other tables as secondary or foreign keys I can create ...
I have a Report that is opened from a Form. The Form has 15 sub-Forms on it and the Report has 12 sub-Reports. If I try to Print the Report (the Form remains open) I get a message box telling ...
Ive read through the previous posts havent found anything on this happening to a single user. Just deployed a DB with shared back end. Each user has a front end. App is supposed to go to main ...
Does anyone have the dirt on special codes like the @ symbol that can be used in MsgBox text which result in specialized formatting like bold etc.?
Or just point me towards the article... ...
I am trying to check for fields that have missing foreign keys in my ExpensItems table. I can get an accurate count when I run a query using Is Null in the criteria for the CostAllocationCd f...
I have an app that does shipping and billing. I have a current invoice report that looks like a QBooks invoice but when I have more than 4 or 5 line items it pushes my information to another p...
Using Access 97, what VBA code can give me the modified date of a table, query, form, or report?
I use Access View Query T-SQL procedure to retrieve data. I need to insert multiple texts into a field concatinating 'carriage return'(Line break) or Newline characters. How do I specify these...
access 2000, vbscript, asp
This is new install on a new machine. I used to know how to do this, but one only does it every now and then.
Even though I close my record set and set the ...
hey guys i hope everything is good well i'm asking this question because i could not find a job
for 3monts and i need to pay bills becuase i just got this appartment i was homeles for 1 year...
I need to determine if a field exists in an Access data table to determine if normal processing should continue. Here's what I've tried to do:
Function DoesFieldExist(ByVal strField As Str...
I have a form which has a button that does an export. I have the code below. When I click the button it attempts to export the form. I actually need it to export a specific table called "ma...
Hello,
I working with an exisitng access application that has a memo field on the of the forms. The problem is the user adds a lot of information into the memo filed and it comes out all m...
I have a textbox in a rptInvNumbersUsed2 detail section that is linked to [CompanyName]. I want to be able to show the data from [ContactMergedName] if there is no values in [CompanyName]. How...
