Search results

I have attached a sample database based of my real one. The real one has proprietary information, so I cannot attach it. I am trying to build a crosstab query that will output a count of items per category per month that "takes an item out of stock" when it expires. For example (where the...

I have a database output that I am trying to import into my database. I do not have access to the other database to create my own output. The database outputs name in format Last, First MI (there are two spaces between the comma and the first name(no idea why) and always a trailing space...

Bottom line: Any idea how to handle the "IsNull" process? I have a form in which the user is to input 5 dates. Three of the 5 dates must occur in sequence, meaning date one MUST come before date two, which MUST come before date three. I am building what is in essence a date sequence checker...

I have a table with many instances of FKs with associated dates. I need to run a query that groups on all FKs and returns the min date for each FK. I tried to build a query that groups by FK, then sorted the dates ascending and set return limit to 1, but as you all already know, that just...

I have a project that I have been developing for the past few years. All of a sudden (today) when I published a new front end, the VBA will not run. I have a loading form that runs a few basic checks (OnLoad), then opens two other forms and closes itself (OnOpen). When I open the .accde...

As mentioned, I have frm1 and frm2. When certain criteria are met in frm1, frm2 opens (pop up, non-modal) to remind the employee there are additional steps needed. The problem is, the trigger for the frm2 open event happens as the employee is receiving/transcribing information at a very rapid...

I have a table that has multiple related tables. I am trying to display (in a from) the total record count of all related tables per record in the main table, but I do not know how to build the query...or if I should be using VBA. For example suppose: tblCompany -CompanyID (PK)...

Anyone know how to see the total number of lines of code in an Access 2007 database? I have tried CountLines() and ContOfLines() (with and without a leading '?') in the immediate window, but it errors, "Compile error: Expected: =" Any ideas?

I am trying to refresh one form from another. I have a table (tblZ) and two forms, frmA and frmB. frmA has a command button (cmdA), an unbound list box (lstA) and a subform (sbfA). The AfterUpdate property of lstA refreshes sbfA. The OnClick property of cmdA opens frmB. frmB is a modal pop...

I would like to be able to create a button on a form that will call a query/report and copy the results in plain text to the clipboard. I am assuming the best way would be to create a hidden text box on the form and assign it's value with VBA, then use the acCmdCopy method. However, I am not...

Has anyone figured out how to import more than 255 charters from a Excel cell into Access 2007? Any help would be greatly appreciated. Thank you in advance.

Is it possible to change form labels to display info that depends on the selection of a combo box? For example, suppose: tblFormData -FormDataID (PK) -FormLabelsID (FK) -Text1 -Text2 -Text3 -Text4 tblFormLabels -FormLabelsID (PK) -LabelForTxtText1 -LabelForTxtText2 -LabelForTxtText3...

I am trying to create a custom error message. I am getting a very odd response. On error, I get an Access-generated Runtime error '3022'. If I hit End then try to close the form, I get my custom error message. The first text box on the form is for Employee ID. After update, it should be...

I have a database which I am building to output html code to a .txt file for uploading to a site. The problem I face is, I cannot figure out how to force a line of text to export as continuous. As it sits, longer lines of code are forced a line break (carriage return) upon export. As for...

I have a db that I am revamping. My question is more along the lines of proper development procedures. Generally speaking, is it better to include combo boxes programmatically in the tbl or should all combo boxes be incorporated in frms only? Does having a combo box in a tbl cause problems...

I have a report with a sub-report that lists incidents. Basically, when an employee has an incident, it is recorded in one table. The report is built off the main personnel table and the incident table through a select query. The problem is this, the report runs fine and displays everything...

I have a report in which I have data displayed in a spreadsheet type format based off of a cross-tab query. The top row headers I have set to vertical, but the text is diplaying "upside down" so to speak. The last letter of the label is at the bottom of the label box, and I am trying to get...

I have a secure db and am trying to use Mail Merge. Each time I try to connect, I get the same error: "You do not have the necessary permissions to use [the db (.mdb)] object. Have your system administrator or the person who created this object establish the appropriate permissions for you."...

I am, once again, begging for the help of the DB geniuses on this forum. I am trying to split my db and am getting the errors you see in the screen shots. Please help! Thank you in advance.

I have a form that I have created using Mail Merge. It draws from a qry in my db. When I open the qry in Access, data is displayed, yet when I hit the merge button in Word, it tells me there is not data that matches. I have verified all of the fields in the MM doc and that they all exist in the...