Search results

Hi, I'm trying to import data from another database (codes), and the text field in that database is set to 7. Our new database only needs the first 5 digits of the codes, so I'm wondering is it possible to create a query that filters any entries where the code field has more then 5 digits?

oh wow, you're right that's much easier. Geeze I wish I could remember this stuff!!!

Got it working :) I changed the source to this SELECT Report_ID, Report_Type FROM tbl_report_type UNION Select 99 as AllChoice , "All" as Bogus From tbl_report_type ORDER BY Report_Type; and then in my onclick of the button, for the 'all' report I changed it's case to 99. This way, if they...

OK, I got it to somewhat work with this SELECT Report_ID, Report_Type FROM tbl_report_type UNION Select Null as AllChoice , "All" as Bogus From tbl_report_type ORDER BY Report_Type; If I bound my dropdown to column 1 all the reports open except the one for all. I'm guessing I'm going to have to...

Here's is what I have for the code on the submit button. Private Sub cmd_addreport_Click() On Error GoTo Err_cmd_addreport_Click DoCmd.RunCommand acCmdSaveRecord ' saves the record. Select Case Me.cbo_addreports Case 1 'Report 1 stDocName = "r_1" Case 2...

Hi, I table that is used for options for some dropdown menus throughout my forms that are used to open reports. On one form, I would like to have a 'all' category appear in my dropdown, but I don't need this on all the other dropdowns that are bound to this table in the database. Is there a...

Hi, Thanks for replying and giving me some suggestions. I'm going to try and describe what I have been working on, and hopefully what you suggested will still work. I have a 'codes' table, this table lists all the codes, code description and any other info related to the code itself We...

anyone have any ideas or thoughts? I know how to find the ones that ended, and find any that started. The users select a date, and all entries have a 'set' start date. So I have a query that looks for any entries with an end date -1 day, to find any that ended the day before. I just can't...

Working on a database that tracks codes, descriptions etc. One of the items they would like is a 'change' report. On this report, they would like it too list 2 things. They would like it to list if any entries that refer to a expired edit type (determined by the end date field). Then if...

Perfect! Thanks

Hi, Working on a query, what I have is a user will select a date on a form and hit submit. I need the query that it runs, to pull all data -1 day from what they select. So if they select 10/31 on the form, it needs to pull everything for 10/30 only. I have this in my query now...

Hi, I'm working on a report, and I've been asked to do something I'm not really sure how to do. Is there a way in a report to have alternate text display depending on the value of a field? So say I have a report that would normally read like this. Field #1..........Field #2 XX.............a...

Hi, I have 2 tables right now, for diffent code types. I've been asked, to add a field for a report called 'Static Text', some codes will have extra text to display on the report. As far as I know, the text will only be used on certain code types. So I'm wondering should I add a 'static...

that was it! I never noticed that Access automatically fills in that field when you make it a number field. Thanks!

That didn't seem to work either. It lets me go right to the next record without any message

Hi, Having a odd problem but I'm sure I'm just overlooking something. I have a combo box, that I need the users to select one of the items. If they leave it blank I want a message to appear telling them what to do. I was using this code Private Sub Form_BeforeUpdate(Cancel As Integer) If...

Anyone have any ideas how to make it do what I need?

Also, not sure if I'm just doing something wrong or not. But if I try and add any other fields to this query (to display on the report) for example we have a comments field. If I add that to the query, the query won't display any results. not sure what I'm doing wrong.

Thank You. Got it working but it's not quite doing what i need to do. I have several entries in the table for code 'XX', and each has an edit_type_id #. I added a new record and gave it the entry type '6'. When I run the query it's only displaying the entry with the 6, and ignoring the rest...

Will this work on a number field? I forgot we changed the database and this field is now Edit_Type_ID so it would be '6' I tried your code out on a different 'text' field, and it worked. But it won't work on this number field.