Find your MS Access answers here and save on IT support.
Questions
Dcount Function
Comments: 1
I have a dcount function that checks to see if a part has been ordered before. I would also like for the dcount function to check the date field and see if its within 5 days from the current date. It works ...
Dlookup
Comments: 10
I have a database that allows users to order parts. When a duplicate part number is ordered I would like a message box to pop up asking if you're sure you'd like to do this. The message box would i...
Message box with yes or no options
Comments: 3
I have a form where users can order parts to be cut on various machines. If the user orders a quantity greater than 25 I would like for a message box to come up when they click save. The message ...
Email using Access 97 and Outlook Express ( Can't Se…
Comments: 9
I'm using access 97 and outlook express to send emails using the docmd.sendobject method. I have this on about 25 computers at my place of work and about five of them are not working. The fiv...
running command on time interval
Comments: 10
Is there a way to automatically refresh a table per a time interval. Or is there a way to refresh a table every time a new entry is made without closing and reopening it or using a manual refresh button.
Sending Multi-Line Parameter to SQL in VB6
Comments: 6
I can't seem to find a way to insert a multi-line text parameter into a SQL table with VB6 ADO. SQL seems to strip the CRLF out of the parameter before inserting into the table. I've attached t...
How to random select record from subset of Access 97 r…
Comments: 17
Hi, I wish to obtain a random flavour for a product that is selected. I have a table called Flavour that has a query FlavourRandom. The query has a parameter of Pid which, when set, limits t...
how to access to a hotmail acc
Comments: 4
how to access to an another acc. of hotmail my niece spend too much time and maybe she is pregnat
Trying to learn some best practices for my code
Comments: 3
Hi All, Could someone take a look at my code and tell me what I should be doing to make it better? I've converted my textbox value (string) to the appropriate datatype but what else do I...
Modify Access 2003 query
Comments: 8
I have a query “ToSplit”. the results of the query : Kind Name Count 1 A 23 1 B 33 2 A 77 2 B 44 i want to modify the table and have a look like this ...
Signiture Imput for Access
Comments: 2
I have a Tablet Pc with access 2010 and would like to be able to take signatures right in the data base any ideas?
Form Does not Display Table Data (only blank new)
Comments: 14
Hello. Access 2007 database. I have a form connected to a table. I have 40 records in the table. The form does NOT display any records. Rather, it only allows for new form entry a...
how can I extract information from a string?
Comments: 4
Hello guys I have this string = Nfev00000169779718_41137.xml I want to extract this information Number_CGC Note ---------------...
Which field is suitable for what I need to do in access?
Comments: 4
Hello guys I have a table that I need to keep xml files. But I have in doubt, which field is suitable for me: A binary field or Object field? Thanks
how can I create a binary field in access by code?
Comments: 6
Hello guys I have this code: Sql.Add('CREATE TABLE NOTAS ('); Sql.Add('NT_ID AUTOINCREMENT PRIMARY KEY,'); Sql.Add('NT_NOTA INTEGER...
Display Number of Records a Query Returns
Comments: 14
I have an Access form used for displaying query results. The form displays a single record. The query I run almost always returns only 1 record. On occsion though, there may be 2 or 3 records re...
Access Query
Comments: 5
I need to be able to select a word from a memo field that sits between "Notification of a " and "on the", is there an easy way to do this?
Microsoft Access 2010
Comments: 1
I just got a newer computer with Microsoft Access 2010 on it. Now, everytime I open an Access database I use all the time I get the error "Certain content in this database has been disabled". I cli...
update a date field with current date- at same time another…
Comments: 5
I use the following statement to let user Enter a new 'current location': UPDATE [TABLE TWO] SET [TABLE TWO].[CURRENT LOCATION] = [Enter New location]; Is there a way...
Create a new field in a query
Comments: 14
My query has a field called: Cert# which displays numbers made up of 9digit plus an alpha character eg. 111111111A. I want to recreate another field in the query which drops the alpha char...
Find everywhere a MACRO is used in ACCESS 2007
Comments: 3
Hello Experts, I have a database that was created in Access 97 and was converted to 2007. I'm in the process of finding each MACRO that used the SETVALUE command and SENDKEYS an...
Access 2007 calculate value in IIF statement in a report …
Comments: 11
Hi, I am running a payroll report in Access 2007 and I want the control source for a text box to perform a calculation as follows; If the value from the field PayerType = Gross Payer ...
Sequence of events.
Comments: 3
Can anyone point me towards a reasonable guide to when "Events" mentioned on a Form in MS Access 2003 are actioned? Some, like "On Click" are fairly obvious, others, like "On Dirty" ar...
Access 2010 change legend text in chart
Comments: 2
Hi In Access 2010 I havew a chart (within a report). I want to change the text in the legend. If I double clivck on the legend I just get the option to format this. How do I actually change t...
Access Reports - Landscape
Comments: 3
Hi I want to build an Access report in a landscape style (not portrait). I would also like it to automatically print it in landscape mode, not sure if this is automatic. What properties/co...