Tagged Questions
10
votes
7answers
793 views
Access sometimes jumps to existing record on save new record - Access2k FE/SQL2005 BE
this is my first question on SO, am really posting this out of desperation after searching around a lot for an answer and trying a few different things with no success.
I have an Access database ...
5
votes
10answers
670 views
wanting to move up from ms access, thinking .net? visual studio?
So I wrote a project-management program for a small business using Microsoft Access 2007.
Now they've requested lots of additional features (timekeeping, privileged data tiers ...)
I personally use ...
3
votes
5answers
96 views
Combining fields, some null, in a textbox on a report in access
I'm trying to amalgamate a few address feilds into one text box on a report:
=[City]+", "+[County]+", "+[Post Code]
However not all records have an entry in the [County] column, which means that ...
3
votes
2answers
103 views
Is there a preferred way to create dynamic, form-based queries in MS Access?
General question regarding the approach to take with a database I'm constructing. I plan on having a few forms that will allow DB business users to enter criteria, restrict their search via radio ...
2
votes
2answers
848 views
MS Access 2003 - Failure to create MDE file: error VBA is corrupt?
Ok so this is a brand new snag I have run into. I am trying to launch a new MDE from my source MDB file, and it is locking up Access.
So in my mdb, I am first compacting and repairing, and then ...
2
votes
1answer
70 views
Avoiding that two fields have the same values
I am using Access 2010.
I have a Table named Person : Id(key), field1(int), field2(int).
I want to avoid that field1 will be equal to field2.
Is this possible?
2
votes
1answer
73 views
Add/Edit Button Giving Datatype Error
I have a main and subform. I have text boxes in the main form that will allow me to add/edit information into the subform. Add works fine but when I try to edit a record, the information of the ...
2
votes
1answer
503 views
VBA Excel Syntax Error Missing Operator in Query Expression Insert Statement
The premise behind this program is to take several different excel sheets and input them in to an access database. Everything is working until my execute statement which produces the following error:
...
2
votes
1answer
56 views
How to apply changes to multiple Access 2003 databases?
I have an Access 2003 database for managing the financials for a project. I would like to have a separate instance of the database for each project.
I'm still working on the basic form of it and ...
1
vote
2answers
129 views
MS Access database in Windows Server 2003 using classic ASP
I'm migrating a classic ASP site from Windows Server 2003 to Windows Server 2008 R2. The problem is that the site are using a Microsoft Access database and using Microsoft.Jet.OLEDB.4.0 as provider.
...
1
vote
3answers
62 views
How can I get the ID of a record when it isn't mentioned on a form in Access 2007 via VBA?
I have a multiple items form which does not mention the ID of the record. I have a button for each row which, when clicked, opens up a new form containing more details.
In the past, I've added a ...
1
vote
1answer
1k views
How to insert hyperlink into access database via sql?
I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive.
However, when I use a SQL ...
1
vote
1answer
282 views
How to add functionality for ComboBox <Select All> in Microsoft Access forms
So I posted a question the other day about an access form that needed to have a "Select All" option added to the 2 ComoBoxes. I was able to add in the option to the 2 of them using a union. However, ...
1
vote
1answer
656 views
Add attachment via VBA in MS Access
One of my form is as follows
It is a form made in MS Access which allows my users to add observations. An observation may include attachments as shown. I am able to click on attachment control and ...
1
vote
2answers
173 views
Access vba block executing when it shouldn't
I have a subroutine that runs when I click a button on my form. The problem is that no matter what happens, the error block is executed, and I can't figure out why. I'm not very good with Access ...
1
vote
2answers
96 views
Inserting Rows in MS Access using IF conditions
I have hourly data (24 hours) for each day for a year. Some hours are missing when there was no data. I need to insert a row with a value of zero when there was missing data to make sure each date has ...
0
votes
8answers
754 views
MS access table as centralised location for storing data [closed]
Is it possible to make my MS access tables as a centralised location for storing data
I have an mdb access file to store data into a table using a form.
Is it possible to enter data to a ...
0
votes
2answers
754 views
Customizing Navigation Buttons' Bar in MS Access Form
I am creating a form in MS Access. My form appears to the user in form of a modal pop-up box. At the bottom of the form we get Navigation Buttons, New Entry (which I have disabled), Filter and Search ...
0
votes
1answer
88 views
Access VBA: Is it possible to execute VBA code when the Access DB opens?
I have 2 forms I'd like to open when the Database opens based on a condition.
Basically
If 'table1' exists in the database, then open form1
Else open form2
Is there a way to get this functionality ...
0
votes
3answers
2k views
Access VBA, unescaped single quotes, Replace(), and null
Working on a script in Microsoft VBA to take a massive flat database and split it between about 20 different tables. The script consists mainly of opening a table, checking every row in the flat ...
0
votes
1answer
37 views
How to prevent to open MS Access database file?
I am developing one Inventory project to sell by using C# and MS Access. After sell this product, Client(or any other) may open the document and read it. I need to overcome this less secure.
I ...
0
votes
1answer
60 views
Automatically append database entries in Access
I want to create a database of products where each product can have multiple colours. I wanted to know if it's possible to create a form which allows the user to enter the Product Name, Colour One, ...
0
votes
2answers
70 views
Getting Access to send emails to dynamic addresses
This is in Access 2010 and I have virtually no experience or familiarity with VBA.
In my form (frmEmailLookup), I have combo boxes and list boxes and a subform set up so that when the user selects a ...
0
votes
0answers
276 views
Updating Records in Access Subform
I have a form/subform. Im trying to set up the button code to add/update records in the subform. Add works fine but when I update it always updates the first record.
Here's my code for update:
...
0
votes
2answers
33 views
Syntax Error Updating Records
I have a form and subform. Im trying to allow updates in the subform with the use of buttons. However my code is giving me.
KEY_ID is text, the other two are number types.
"Syntax error in query ...
0
votes
1answer
197 views
Access Buttons VBA Problems and Subform Issues
Im working on a key inventory database. Something to manage who signs out room keys and when they bring them back in. I've created the tables I plan on using and have started working on the forms. ...
0
votes
0answers
154 views
How to specify PathToSubformControl for BrowseTo in access 2010
Could someone help me with BrowseTo macro plsease? I cannot figure out one of the arguments in the this macro in ACCESS 2010 which is PathToSubformControl. I have this Form called "frm_navigation":
...
0
votes
2answers
104 views
ERROR MSG :You cannot add or change a record because a record is required in header_generator
Hey guys ive been looking online and seeing a lot of comments about cascading deletes, Relationships and enforcing referential Integrity. However i still cannot find my error where i have went wrong, ...
0
votes
0answers
103 views
Access and VBA structure for web-client integration later on? [closed]
I'm developing an Access database that pulls variables via ODBC, receives input from end users, and uses the variables from both to do a calculation. The best way to explain the process is that it's ...
0
votes
1answer
83 views
Group people to maximize chance of reaching the quota of each group (MS Access)
I have a random group of people who receive multiple services and need to stratify them by service received. There are 7 services, each of which has a quota in order to be representative of the whole.
...
