Search results

I'm getting an error that says my query is corrupt. I've dumbed it down to this: UPDATE [tcg CSV] SET [tcg CSV].[My Price] = 10 Where ([tcg CSV].[My Price] Is Null); Whereas this works fine: UPDATE [tcg CSV] SET [tcg CSV].[My Price] = 10; Not sure why, been using this query for awhile now...

well browse to with only [statusID]<10 works just fine, when I limit it even more with ([focDate]-6<=Date() Or IsNull([focDate])) it stops showing the list I think it has something to do with the OR, or maybe the condition is too complex

I have a datasheet that is filtered when you click any of a few buttons I use browseTo. A few of the buttons will show the quick filter list. The code for the browseTo is all the same except for the where condition field. The buttons with these codes does not show a drop down list when I try...

Diamond order and special subs new are both queries, ID is a primary key for diamond order and special subs new is a query with three tables that all have primary keys as well. I've attached the design view for both. I realize the tables/queries are not joined, they are joined by this...

Sorry, it currently says invalid procedure call. When I tried to simplify it, I got a message about the join expression not supported. Series is the name of a comic series, Orig is the name of a generic subscription. For example Series=All New Avengers Orig = Avengers The user wants to...

This worked before, not sure why it is no longer working Here is my query INSERT INTO [add to list] ( Series2, Publisher, comic, Qty, special ) SELECT [diamond order].Series, [diamond order].Publisher, [diamond order].comic, [diamond order].Qty, [special subs new].special FROM [special subs...

Trying to calculate the hours my employees have worked. The table format I'm using can't be altered, its created by our pos program. For example I have fldUserID fldTime fldType fldDate blake 12:04:38 PM Begin Shift 6/3/2018 blake 6:31:44 PM End Shift 6/3/2018 sam 9:22:06 AM...

thanks, going to find someone to develop something for me.

maybe I should look into powerapps?

Considering getting a sharepoint account, but I would like to make it so customers can login with a password to access their data. How would I do that in a web app? My database could be as simple as list of comics, list of customers and list of subscriptions (who is subscribed to what). But it's...

Hello, I have a database that I would like to put online most likely using sharepoint? It's a list of comic subscriptions, I'd like for our customers to see what they are subscribed to, possibly make changes. It's a pretty simple database, at least the part that I would upload. However...

Is is possible to use a combo box but not show the drop down? I've disabled it so it isnt possible to change, but I would prefer it to appear like a regular text box. The combo box has two columns, ID and name, it auto selects the ID when loading and shows the user the name. Unless that's...

I have a query that takes a text field and removes "#" leaving just a number Number:Right([issue],Len([issue])-1) Then I made another query trying to use the max total of this number, it works except for it is returning 8 as a max instead of 10. It's not seeing 8 as 08. It seems like it is...

I got it to work by removing the totals. Thanks for the help

I'm getting the error: expression is typed incorrectly or it is too complex Basically I want to truncate before either a " #", " annual", or " tp" series1: Left([comic],IIf(InStr(1,[comic]," #")=0,Len([comic])+1,InStr(1,[comic]," #"))-1) series2: Left([series1],IIf(InStr(1,[series1],"...

that might be it then because I have not updated office in quite awhile.

no more error, but still not working. The screenshot below is win7

I have 3 tables, one for customers, one for comics, one for subscriptions. Is there a way to make a crosstab query that would show if a customer has an existing subscription or not? The value would I guess need to be created somehow, based on if there is an entry listed in the subscription...

Well the day is still wrong, but this version shows an error when I open the report: MS Access database engine does not recognize '[4/27]' as a valid field name or expression This seems to be caused by the report you made "daily week comparison rep", it shows up blank and gives the same error...

Nope, still showing wrong date. Thanks for your help, looks like I will need to make smaller report compilations