Search results

Thanks to some complete MORON who obviously doesn't know the basic concepts of database development and implementation, I am in the unfortunate position of having to work around their stupid constructs to try to get useful data into our own internal database. And now for my convoluted...

I have an invoice report that has a calculated control for billing cycle. Currently it is set to =[Enter start date] & "-" & [Enter end date] This is because the start date depends on the date of the first charge and changes every month, so the user enters the dates simply for display...

I have a module that runs when I check a checkbox that adds the existing record to a second table (1-1 relationship). It works just fine except that when I return to the master form, there is a new blank record that has been added after the one that I checked the box for. Any ideas why this is...

I have a main form DriverID Date Payments Charges Total (=[Payments]-[Charges]) Charges are logged in the form's datasheet-subform where they are totaled in the subform's invisible footer. I'm populating the Total field in the main form by calling the subform's total value using ...

I have created numerous unbound combo boxes in my time working with Access. For some reason, now, one of my cbs will only display data from the key field column, not the data column. It is set up to be based on a simple SQL statement drawing from the table (only 2 fields in the table), to...

I am using the following expression to give me the first initial of the first and last names (concatenated into the "Name" field): Initials: Left([Name],1)+Mid([Name],InStr([Name],""),2) Does anyone have any ideas on how I might be able to accommodate for hyphenated surnames (such as: John...

I have a command button on a form that I only want to enable when the value of one of the text fields is not null (has data) and want the button to be disabled when the text field has no data. For some reason, the code does not seem to be working; any suggestions? If IsNull(Me!ApplID) Then...

I know this should be a simple "duh" solution, but some of my Access skills are getting rusty, and after an hour of searching various terms, still haven't come up with an answer. I added a subform to a main form with the correct parent-child linkage setup. Mainform Parent field is PK, subform...

I have an unmatched query that I want to use to find all the records that don't match (obviously) the ID fields, but I also want to set additional criteria on the ID field so that it doesn't pull archived data out of the first table. So basically, T1 has the full set of data, old and new. T2...

I have a bunch of queries set up with outer joins so that they should return all records from one table and only matching records from another table. The problem is, they aren't all working as they are supposed to be (and oddly, some of them are). Here is the SQL statement I'm using and the...

I'm reworking a database that someone else designed in which they used the following code to pass values selected from a combo box into a memo field with comma separators. I would like to accomplish the same thing using a multi-select list box but I'm not having much luck. I admit, my coding...

I have a report that displays recipe cards; ingredients list is generated with a subreport. The basic setup works fine, but I want to use a form to filter all recipes that contain certain ingredients. When I enter an ingredient parameter into the query that drives the main report, I get the...

I thought I had this figured out, but for some reason it's still not displaying correctly. I need to display text values as the x-axis (poor, fair, good, excellent) in that order. The values are linked to a numeric "scale" so that Poor = 1 (in separate fields but the same table); both fields...

I have been experiencing several issues related to Compact and Repair on my database. The original file is 125MB and I deleted some obsolete records (not many though) and several unused tables, forms, and reports trying to get the db back down to a more manageable size for off-site users...

I am putting charts into a report in Access that draw data from a query. the query is a summary query that counts the total instances of each response, and the response value is used as the series for the x-axis in the chart, with the bar showing how many respondants their were for each one...

I am working on a database that users will use to enter data into forms based on pre-determined info. For instance, they will be rating a course on a series of measures which I will have entered into the database already, thus "creating" their response records, and they are simply completing...

We are operating an Access2003 database on WindowsXP and cannot get the reports in the database to open. No error messages appear, nor do the reports. -The database is stored on the C:\ and the user has full permissions on that folder AND the database -Network printer is installed -Reports DO...

We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc. Is there a way, in...

I'm experiencing an interesting problem with a database I have been working on. For some reason, when I tried to enforce referential integrity between two fields, whose values should have matched perfectly, I got an error that I couldn't because they didn't match. When I ran an unmatched...

We have a database that was created in Access2000 and when opened in (or converted to) Access2003, commas in the query criteria fields change to vertical bars. The query still runs OK, but when you try to modify it (by adding another table or something) you get an error message: "Invalid use of...